To create a database connection cache for the PostgreSQL database using the SSL method:
-
After configuring the settings in the General tab, select the SSL tab.
-
Select the SSL mode.
-
Disable -- Client is using an unencrypted connection.
-
Prefer -- Client attempts to connect using encryption, falling back to an unencrypted connection if an encrypted connection cannot be established.
-
Require -- Client requires an encrypted connection and fails if one cannot be established.
-
-
Enter or select your client certificate.
-
Click View License Terms to view the driver license and then select the check box of "I have read and agree to the license ...".
For PostgreSQL, SQL Server, SQL Anywhere, or ASE, the corresponding .NET Core data provider is packaged with the IDE and will be loaded immediately after you have viewed and accepted the license terms.
-
Click Test Connection to make sure the connection is successful.