Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
FATAL: pg_hba.conf rejects connection for host [IP address] , user [user name], database [database name] [, SSL off]
Symptoms
The error may occur during the import into a PostgreSQL database that is configured to use a SSL connection.
Causes
The error message appears when trying to import into a database that is using a SSL connection. The PostgreSQL server does not have an entry in its configuration file.
Solutions
To resolve the issue, add a new entry to the pg_hba.conf file as described in the PostgreSQL documentation, so that the PostgreSQL server is able to accept a connection with the required IP address. To do this, you need to contact your database administrator.
In case of any questions or difficulties, feel free to contact us at support@ispirer.com