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:
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
