Re: psql: FATAL: Password authentication failed for

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(at)fastcrypt(dot)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..
>
> thanks,
> kuru
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!