I installed PostgreSQL under an account named postgres, using the
installer project.

dcorbit@DANNFAST ~
$ psql -h localhost -U postgres -W template1
psql.exe: FATAL:  Password authentication failed for user "postgres"

Wed, 1 Sep 2004 14:57:40 -0700
"Dann Corbit" <DCorbit@connx.com>
PostgreSQL 8.0 Beta 2 does not prompt for password when requested:


Dann Corbit wrote:

>I installed PostgreSQL under an account named postgres, using the
>installer project.
>
>dcorbit@DANNFAST ~
>$ psql -h localhost -U postgres -W template1
>psql.exe: FATAL:  Password authentication failed for user "postgres"
>
>
>  
>

"-h localhost" is redundant on Windows - it's the default (since we have 
no Unix sockets)

Is there a .pgpass file that it somehow picked up?

cheers

andrew



Wed, 01 Sep 2004 18:57:13 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: PostgreSQL 8.0 Beta 2 does not prompt for password