Postgres Pro
Downloads
Home   >   mailing lists

Thread: Another help needed on Window client

Another help needed on Window client

From
Vernon
Date:
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/

Re: Another help needed on Window client

From
Tony Caduto
Date:
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
>
>
>
>

Re: Another help needed on Window client

From
Tom Lane
Date:
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