Re: psql: FATAL: Password authentication failed for

That doesn't answer the question of why he isn't even asked for a password.

cheers

andrew

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 <andrew(at)dunslane(dot)net> 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
>
>
>