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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
