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

>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(at)yahoo(dot)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