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