Red Hat Single Sign-On (RH SSO) fails to connect to an external PostgreSQL Database returning a "no pg_hba.conf entry for host" error message

Solution Verified - Updated -

Issue

RH SSO is returning the following error when configured to use an external PostgreSQL Database:

Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "1.1.1.1", user "<USERNAME>", database "<DATABASE>", SSL off

Environment

  • Red Hat Single Sign-On (RH SSO)
    • 7.X

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content