Re: psql: FATAL: Password authentication failed for

Which database are you trying to connect to?

try: psql -U postgres template1
or psql -U postgres -W template1
and see what happens

cheers

andrew

Sudhakar Kurumella wrote:

> I tried that, the error is the same but with user "postgres"
>  
> [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres
> psql: FATAL:  Password authentication failed for user "postgres"
>  
> It is not taking my password if i give option with "-W" as well.
>  
> [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -W password
> psql: FATAL:  Password authentication failed for user "postgres"
>  
> thanks,
> kuru
>  
>
>
> */Dave Cramer <pg@fastcrypt.com>/* wrote:
>
>     Use psql -U postgres
>
>     Dave
>     On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
>     > Hi,
>     >
>     > I am using postgresql windows based "8.0-beta2-dev3". I have
>     provided
>     > default user and password while installing. When i am trying to
>     > connecto to psql through dos command prompt, i am getting following
>     > error:
>     >
>     > [D:\Postgresql\8.0-beta2-dev3\bin]psql
>     > psql: FATAL: Password authentication failed for user "Administrator"
>     >
>     > I dont have user named "Administrator", i have only user "postgres"
>     > and my "pg_hba.conf" details are:
>     >
>     > # TYPE DATABASE USER CIDR-ADDRESS METHOD
>     > local all postgres md5
>     > # IPv4-style local connections:
>     > host all all 127.0.0.1/32 md5
>     > # IPv6-style local connections:
>     > #host all all ::1/128 md5
>     >
>     > My question is how to connect postgres through the dos command
>     prompt,
>     > to use commands such as pg_dump etc..
>     >
>
>