Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
pg_hba.conf issues
Symptoms
During the import into PostgreSQL database which is tuned to set to use SSLmode=require.
FATAL: no pg_hba.conf entry for host
Causes
- This error message 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