Re: psql: FATAL: Password authentication failed for

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(at)forgeahead(dot)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!