C22: Authentication failed / pg_hba.conf rejects connection
Work in Progress
This documentation page is currently being worked on. We apologize for the page being incomplete or not available yet.
Category: Connection Events
SQLSTATE: 28000 (Class 28 - Invalid Authorization Specification: invalid_authorization_specification), 28P01 (Class 28 - Invalid Authorization Specification: invalid_password), 55000 (Class 55 - Object Not In Prerequisite State: object_not_in_prerequisite_state)
Urgency: low
SQLSTATE: 28000 (Class 28 - Invalid Authorization Specification: invalid_authorization_specification), 28P01 (Class 28 - Invalid Authorization Specification: invalid_password), 55000 (Class 55 - Object Not In Prerequisite State: object_not_in_prerequisite_state)
Urgency: low
Example Postgres Log Output:
FATAL: pg_hba.conf rejects connection for host "172.1.0.1", user "myuser", database "mydb", SSL onFATAL: no pg_hba.conf entry for host "8.8.8.8", user "postgres", database "postgres", SSL offFATAL: password authentication failed for user "postgres"
DETAIL: Connection matched pg_hba.conf line 4: "hostssl postgres postgres 0.0.0.0/0 md5"FATAL: database "template0" is not currently accepting connectionsFATAL: role "abc" is not permitted to log inLOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused
FATAL: Ident authentication failed for user "postgres"Explanation:
...
Recommended Action:
...
Learn More:
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →