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.