Re: psql: FATAL: Password authentication failed for - Mailing list pgsql-hackers

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 <kocka@forgeahead.hu>/* 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!