Prerequisites to Configure Oracle GoldenGate Extract for PostgreSQL

To use Oracle GoldenGate 21.3 for PostgreSQL on OEL8, you must explicitly install OpenSSL 1.0 version on the OEL8 instance. This is necessary because the libpq library (packaged with Oracle GoldenGate 21c (21.3) for PostgreSQL), has a dependency on OpenSSL 1.0 version libraries, and these libraries are not available on OEL8 by default.

To capture from a PostgreSQL database, Oracle GoldenGate requires the test_decoding database plug-in be installed for the database. This plug-in might not have been installed by default when the database was installed.

Ensure that the postgresqlversion#-contrib package is installed on the database server, as shown in the example:

sudo yum install postgresql14-contrib