Re: [HACKERS] psql: FATAL: Password authentication failed for

[Andrew Dunstan]

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 <[EMAIL PROTECTED]>/* 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..
    >

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match