The following bug has been logged online:

Bug reference: 1452
Logged by: Jonathan Chen
Email address: chenjh (AT) uci (DOT) edu
PostgreSQL version: 8.0
Operating system: Windows Server 2003
Description: psql and other programs don't offer a password prompt,
so I can't login to databases
Details:

When I run psql or other programs (e.g. pg_dump), it never even gives me a
password prompt, so of course I get the following error message:

psql: FATAL: password authentication failed for user "CDBUSER"

I've tried running with the "-W" option, but doesn't seem to make a
difference. Complete command-line:

psql -U CDBUSER -W cdbtest

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org