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 /* 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: FAT AL: 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
>
> - 50x more storage than other providers!