Using the native connector to PostgreSQL in SSL mode

dgudkov · August 30, 2018, 10:36am

The native connector for PostgreSQL doesn’t have a setting for SSL mode, but it can be activated using custom properties:

SSL mode = Require

jaws2k · August 6, 2020, 5:33am

Hi dgudkov,

Thanks for this - we have recently started enforcing SSL connections to these databases.

When I set this custom property, I receive the following error:

Test connection failed:
42704: unrecognized configuration parameter “ssl_renegotiation_limit”

As I’m not specifying this parameter, I guess it’s applied automatically. I’ve read into the error and it appears this parameter was deprecated.

Is there a way around this?

andrew.rybka · August 6, 2020, 8:15am

Hi Aaron,

What version of PostgreSQL you are using? You can get the full version with the following SQL command:

SELECT version()

Or you are using Amazon Redshift?

tegshe · August 6, 2020, 9:12am

Hi Andrew,

I’m getting same error. I’m trying to connect to Amazon Redshift cluster.

andrew.rybka · August 6, 2020, 9:40am

Hi Tegshe,

Try to add the following custom property:

Server Compatibility Mode = Redshift

jaws2k · August 7, 2020, 2:16am

Ah - yes, apologies - this was for a Redshift connection. I can confirm the above custom property works, and it doesn’t appear to be an issue for our actual PostgreSQL databases.

dgudkov · October 15, 2021, 11:24pm

The option to enable SSL has been added in the native Postgres connector in v.5.