Another help needed on Window client
Here is my situation:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\Program Files\PostgreSQL\8.0>runas /user:user01
cmd.exe
Enter the password for user01:
Attempting to start cmd.exe as user "<D..>\user01" ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A new command prompt window is popup. In the new
command prompt window, I have the following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\PROGRA~1\PostgreSQL\8.0>bin\psql template1
Password:
psql: FATAL: password authentication failed for user
"user01"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here I type into the same password as in the previous
command and that is the password used during the
installation.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\PROGRA~1\PostgreSQL\8.0>bin\createdb mydb
Password:
createdb: could not connect to database template1:
FATAL: password authentication failed for user
"user01"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have tried to find out any document on the subject
(that is the Window client) without success. I am
wondering whether a file contains the readable
authentication information or not.
Thanks,
Vernon
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
You need to set your pg_hba.conf file to allow trusted authentication
for 127.0.0.1
i.e.
host all all 127.0.0.1/32 trust
Vernon wrote:
Show quoted text
Here is my situation:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\Program Files\PostgreSQL\8.0>runas /user:user01
cmd.exe
Enter the password for user01:
Attempting to start cmd.exe as user "<D..>\user01" ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~A new command prompt window is popup. In the new
command prompt window, I have the following:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\PROGRA~1\PostgreSQL\8.0>bin\psql template1
Password:
psql: FATAL: password authentication failed for user
"user01"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Here I type into the same password as in the previous
command and that is the password used during the
installation.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\PROGRA~1\PostgreSQL\8.0>bin\createdb mydb
Password:
createdb: could not connect to database template1:
FATAL: password authentication failed for user
"user01"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~I have tried to find out any document on the subject
(that is the Window client) without success. I am
wondering whether a file contains the readable
authentication information or not.Thanks,
Vernon
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Vernon <vwu725@yahoo.com> writes:
C:\Program Files\PostgreSQL\8.0>runas /user:user01
cmd.exe
Enter the password for user01:
Attempting to start cmd.exe as user "<D..>\user01" ...
A new command prompt window is popup. In the new
command prompt window, I have the following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\PROGRA~1\PostgreSQL\8.0>bin\psql template1
Password:
psql: FATAL: password authentication failed for user
"user01"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here I type into the same password as in the previous
command and that is the password used during the
installation.
It sounds like you are assuming that the Windows system password for
user01 is the same as the Postgres password for user01. This is not
necessarily true. You might want to go in and directly do an ALTER USER
WITH PASSWORD command to be sure you have the right Postgres password
set. (If you can't get in to do that, temporarily set auth method
"trust" instead of "md5" in the pg_hba.conf file.)
regards, tom lane