PostgreSQL Password Authentication Error…but cannot find account


I'm getting the following error within the PostgreSQL log file. When an external service is calling the DB for map routing, the following error appears. However, within “Login/Group Roles”, the user doesn't exist.

I've also checked pg_hba.conf and the User stated there is Administrator.

Where is this account being referenced? I'm struggling to get any additional logging in order to tell me.

Help would be appreciated 🙂

2019-11-29 11:14:32 GMT FATAL:  password authentication failed for user "Admin"
2019-11-29 11:14:32 GMT DETAIL:  Role "Admin" does not exist.
    Connection matched pg_hba.conf line 88: "host   all all samenet md5"

Best Answer

You'll have to use a user that exists for the login. Like the error message says, there is no user Admin.