Password authentication on Windows psql

Lists: pgsql-bugs
From: "Filip Hrbek" <filip(dot)hrbek(at)plz(dot)comstar(dot)cz>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Password authentication on Windows psql
Date: 2005-02-01 15:13:56
Message-ID: 006301c50870$a6a92730$1e03a8c0@fhrbek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Hello,

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.0
Similar bug report: #1354

Best regards
Filip Hrbek