Skip to main content

Configuring SSL mode on a PostgreSQL Datasource

For PostgreSQL Datasource connections that require securing data in motion, use this article as a guide for adding a secure socket connection to a PostgreSQL Datasource.

Configuring SSL mode​

From Datasources, choose to add a New Datasource, then SQL, and select Generic JDBC.

Use the following connection string format, replacing the <placeholder> values with information relative to the connection added to Informer:

jdbc:postgresql://<URLToPostgres>:<port>/<database>?user=<user>&password=<password>&sslmode=require

Driver Class name:

org.postgresql.Driver

Schema (default):

public

Test the connection to verify secure access, then Save the connection.

Take note of the available Connection Properties on the Generic JDBC Datasource configuration screen. Connection Properties are translatable to values from the connection string.

Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Datasources.