Return
-
Title
"User does not exist" or "password authentication failed for user" in PostgreSQL agent -
Description
PostgreSQL agent cannot connect to server due to the following errors
User does not exist - org.postgresql.util.PSQLException: FATAL: role "user" does not exist
or
FATAL: password authentication failed for user "user"
-
Cause
This is caused by invalid access credentials to the server, most likely because the user supplied to the agent is incorrect or does not exist -
Resolution
Verify that the user account credentials are correct and the user exists. -
Additional Information
Source: Foglight for PostgreSQL Installation and Troubleshooting guide.