Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

How to Connect To PostgreSQL Using SSL

When migrating your source database into PostgreSQL you may need to have a possibility to connect to the target database using SSL connection. For that purpose Ispirer SQLWays Wizard has a set of options that allows to use SSL connection.

SSL Options

To be able to connect to the target PostgreSQL database using SSL you need to set SSL options that located on the “Advanced” window, on the “Choose a Target Database” page:

On the “Advanced” window please check “Use SSL Connection” option and after that you will be able to select SSL mode. And according to the SSL mode provide a path to the required certificates.

Please note:
If you will use “disable” mode, then you will not need to provide additional information about the certificates.
If you will use “allow”, “prefer” or “requireSSL mode, then you will have to provide a paths to Client Certificate and Client Key.
If you will use “verify-ca” or “verify-fullSSL mode, then you will have to provide a paths to Client Certificate, Client Key and Root Certificates in appropriate options.


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/faq/postgresql-ssl-connection.txt · Last modified: June 12, 2020, 10:53:32 AM by alexandr.kirpichny
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement