Re: [HACKERS] psql: FATAL: Password authentication failed for

[Andrew Dunstan]

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 <[EMAIL PROTECTED]>/* 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!

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])