Introducing our new eBook: "Best Practices for Optimizing Postgres Query Performance"Download Now

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 "172.1.0.1", user "myuser", database "mydb", SSL on
FATAL: no pg_hba.conf entry for host "8.8.8.8", user "postgres", database "postgres", SSL off
FATAL: 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 connections
FATAL: role "abc" is not permitted to log in
LOG: 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 →