Thread: Password authentication on Windows psql

Password authentication on Windows psql

From
"Filip Hrbek"
Date:
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