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

try
 host all all 127.0.0.1/32 trust

restart the server, then try to connect.

Sudhakar Kurumella wrote:

> Is there any alternative for me ?...Any suggestinons would be highly 
> appreciated.
>  
> thanks,
> kuru
>
> */Andrew Dunstan <andrew@dunslane.net>/* wrote:
>
>
>     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 /* 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
>     > &g t; > 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:
>     & gt; > > > 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 - Register online to vote today!
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Mail 
> <http://us.rd.yahoo.com/mail_us/taglines/50x/*http://promotions.yahoo.com/new_mail/static/efficiency.html> 
> - 50x more storage than other providers!