Re: psql: FATAL: Password authentication failed for

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 postgresql 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 - Register online to vote today!