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

Started by Dann Corbitover 21 years ago2 messages
#1Dann Corbit
DCorbit@connx.com

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"

#2Andrew Dunstan
andrew@dunslane.net
In reply to: Dann Corbit (#1)
Re: PostgreSQL 8.0 Beta 2 does not prompt for password

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