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

Example Postgres Log Output:

FATAL: pg_hba.conf rejects connection for host "", user "myuser", database "mydb", SSL on
FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off
FATAL: password authentication failed for user "postgres"
DETAIL: Connection matched pg_hba.conf line 4: "hostssl postgres        postgres               md5"
FATAL: database "template0" is not currently accepting connections
FATAL: role "abc" is not permitted to log in
LOG: could not connect to Ident server at address "", port 113: Connection refused
FATAL: Ident authentication failed for user "postgres"



Recommended Action:


Learn More:

No additional resources available.

Download Free eBook: The Top 6 Postgres Log Events
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →