1. Veridata 23c (23.1.0.0.0)
  2. Secure
  3. Connecting Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL Database

7.8 Connecting Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL Database

SSL SYNTAX: database.url=jdbc:postgresql://<machine_name>:5432/<db_name>?sslmode=verify-ca&sslrootcert=<full path of the cert>/root.crt

Example URL: database.url=jdbc:postgresql://phoenix007:5432/postgres?sslmode=verify-ca&sslrootcert=<path>/root.crt

To connect Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL:
  1. Copy the root certificate root.crt in your agent location and provide full path of it for sslrootcert parameters.
  2. For sslmode there can be two values verify-ca and verify-full.

Parent topic: Secure