Thread: PostgreSQL 8.0 Beta 2 does not prompt for password when requested:

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"

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