How to connect to PostgreSQL/Amazon Redshift using SSL without validating the server certificate?

Created
October 08, 2021 23:21

Date Posted: 2019-02-21
Product: TIBCO Spotfire®

Problem:

Solution:

How to connect to PostgreSQL/Amazon Redshift using SSL without validating the server certificate??

Append '?ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory' at the end of the connection URL. This will make the driver to enable SSL and to use the NonValidatingFactory.

Here is a sample connection URL:

<connection-url-pattern>jdbc:postgresql://host:port/database?tcpKeepAlive=true?ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory</connection-url-pattern>

https://jdbc.postgresql.org/documentation/91/ssl-client.html
https://jdbc.postgresql.org/documentation/head/ssl-client.html

Related articles