Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial

No pg_hba.conf Entry For Host SSL Off

Symptoms

During the import into PostgreSQL database which is tuned to set to use SSLmode=require.

Causes

  • This error message appears when trying to make an import into database that uses SSLmode= require without setting SSL options in the SQLWays Wizard tool.

Solutions

To solve this issue please set SSL mode options on the “Advanced” window on “Target Options” page. Please, provide correct information in the SSL Settings options:

It should solve the “No pg_hba.conf Entry For Host SSL Off” error.


If you face some difficulties or have any additional questions, please feel free to contact us: support@ispirer.com