The following bug has been logged online:
Bug reference: 2000
Logged by: Todd
Email address: tdoolitt@comcast.net
PostgreSQL version: 8.1 Beta 4
Operating system: Windows Xp home
Description: psql does not prompt for password
Details:
psql -U postgres does not prompt for password and responds with...
psql: FATAL: password authentication failed for user "postgres".
even when I pass the -W option it doesn't prompt for password and gives me
the error above. I deleted and recreated my cluster and get the same
result. I can connect to the database using PgAdmin as user postgres.