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
>
>
>
>
