I have a problem with psql on Windows XP Pro. After an attempt to connect to a database I get this error:
psql: FATAL: password authentication failed for user "<username>"
This happens both for local (Windows) and remote (Linux) database. Both databases are easily accessible from other clients (psql for Linux, pgAdmin III, jdbc).
The problem is that there is no password prompt even if I try to force it by -W option. According to pg_hba.conf, there should be no need to ask for password at all (local/all databases/trust).
There is the same error message in the postgresql log as on the screen (see above).
Version: psql (PostgreSQL) 8.0.0Similar bug report: #1354
Best regards Filip Hrbek