Hello,
I have a problem with psql on Windows XP Pro. After an attempt to connect t=
o 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 dat=
abases are easily accessible from other clients (psql for Linux, pgAdmin II=
I, jdbc).
The problem is that there is no password prompt even if I try to force it b=
y -W option. According to pg_hba.conf, there should be no need to ask for p=
assword 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.0
Similar bug report: #1354
Best regards
Filip Hrbek