Skip to content

PostgreSQL Data Source Connections

You can use any supported version of Aurora PosgreSQL with Okera. Okera has tested its PostgreSQL support using the following PostgreSQL versions: 9.5.25, 9.6.22, 10.14, 11.2, and 12.7.

Here is a programmatic example of a PostgreSQL connection.

CREATE DATACONNECTION psql_connection CXNPROPERTIES
(
  'connection_type'='JDBC',
  'jdbc_driver'='postgresql',
  'host'='<A cloud url or host accessible from the application>',
  'port'='<Port to connect to the DB, typically 5432>',
  'user_key'='awssm://my-username',
  'password_key'='awssm://my-password',
  'jdbc.db.name'='dev',
  'jdbc.schema.name'='public',
  'connection_properties'='{"ssl":"true","sslrootcert":"s3://rds-downloads/rds-ca-2019-root.pem"}'
);

Note: sslrootcert is required if ssl is set to true