Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
FATAL: no pg_hba.conf entry for host
Symptoms
During the import into PostgreSQL database which is tuned to set to use SSLmode=allow, prefer, require, verify-ca or verify-full.
FATAL: no pg_hba.conf entry for host ...
Causes
- This type of error appears when trying to make an import into database that uses SSL mode, but there is no match for the client's network address in the pg_hba.conf client authentication rules file.
Solutions
To solve this issue please set up the pg_hba.conf as described in https://methoddev.com/blog/postgresql-windows-encrypted-connection-ssl#:~:text=Step%206%3A%20Force%20PostgreSQL%20SSL%20Connection
If you face some difficulties or have any additional questions, please feel free to contact us: support@ispirer.com