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

[Andrew Dunstan]

The "local" line has no effect on Windows - it only has relevance for 
Unix domain socket connections, which Windows does not support.

The line that affects local connections on Windows is "host all all 
127.0.0.1/32 ..."

(We really need to make that crystal clear in the pg_hba.conf ...)
cheers
andrew
Sudhakar Kurumella wrote:
Dear Laszlo,
 
Indeed that is tough, It is highly appreciated if you could explain a 
bit in detail. I tried with option "password no need" in my server, 
and also tried remove md5 from pg_hba.conf :
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         
postgres                                                     md5
 
it is not working.
thanks
kuru
*/Laszlo Hornyak <[EMAIL PROTECTED]>/* wrote:

    You could enable local connections with no password, then connect with
    your postgres user, change pwd, and then re-enable security.
    use pg_ctl reload for reloading security settings.
    Not nice, but quick :)

    On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
    > I am trying to connect to database called "sos", i tried as you
    said:
    >
    > [D:\]psql -U postgres template1
    > psql: FATAL: Password authentication failed for user "postgres"
    > [D:\]psql -U postgres -W template1
    > psql: FATAL: Password authentication failed for user "postgres"
    > [D:\]
    >
    > I got the above error again.
    >
    > thanks,
    > kuru
    >
    > Andrew Dunstan wrote:
    >
    > 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
    > /* wrote:
    > >
    > > Use psql -U postgres
    > >
    > > Dave
    > > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
    > > > Hi,
    > > >
    > > > I am using postgr esql 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..
    > > >
    > >
    > >
    >
    >
    > ---------------------------------
    > Do you Yahoo!?
    > vote.yahoo.com - Register online to vote today!
    ---------------------------(end of
    broadcast)---------------------------
    TIP 8: explain analyze is your friend
------------------------------------------------------------------------
Do you Yahoo!?
vote.yahoo.com <http://vote.yahoo.com> - Register online to vote today! 

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html