Return
-
Title
pg_hba.conf error when trying to connect to a Postgres database -
Description
When trying to connect to a PostgreSQL database, the following error appears:
'Connection failed because of the following error: "no pg_hba.conf entry for host "IP_ADDRESS", user "USER_NAME", database "DATABASE_NAME", SSL off" ' -
Cause
Postgres issue -
Resolution
This is a Postgres configuration/authentication issue, relating to the pg_hba.conf file, rather than an issue specifically with Toad Data Modeler.
Please can you check the following link (19.1. The pg_hba.conf File) for more details