Re: PSQLException: FATAL: password authentication failed for user "XXX"

pawel_kukawski <kukismen(at)gmail(dot)com> writes:
> I have experienced authentication problems after applying a security
> patch(147440-09) to Solaris 10.

> PostgreSQL 9.2.1
> JDBC: 9.2 1002

> I got the following exception during startup of my application:
> Caused by: org.postgresql.util.PSQLException: FATAL: password authentication
> failed for user "XXX"

You might try looking into the postmaster log to see what the server
logged about it --- the log entries are frequently more verbose than
what the client got told. Also, if the problem isn't immediately
obvious from the log entry, try turning on log_connections to verify
that the JDBC app is connecting with the database+username and from
the IP address that you're expecting.

regards, tom lane