7 Installing Oracle GoldenGate for PostgreSQL Databases
Learn about the requirements and how to install Oracle GoldenGate for PostgreSQL databases.
Topics:
- Operating System Privileges
- Other Programs and Settings
- Where to Install Oracle GoldenGate
- Installing for PostgreSQL
- Installing the DataDirect driver for PostgreSQL
Parent topic: Installing Oracle GoldenGate for Heterogeneous Databases
Operating System Privileges
See Operating System Privileges for general information about the operating system requirements.
Parent topic: Installing Oracle GoldenGate for PostgreSQL Databases
Other Programs and Settings
PostgreSQL libpq Module
For Oracle GoldenGate installations beginning with release version 19.1.0.0.220419 and
after, required PostgreSQL libpq
libraries are now packaged with the
Oracle GoldenGate installation and do not need to be installed separately.
For Oracle GoldenGate installations prior to release version 19.1.0.0.220419, PostgreSQL
libpq
libraries need to be manually installed where Oracle
GoldenGate is to be installed. Perform the instructions below to install the correct
libpq
module when running Oracle GoldenGate release versions prior
to 19.1.0.0.220419.
libpq
module are:
-
Follow the steps to install the required PostgreSQL package available at: https://www.postgresql.org/download/.
-
Select the Linux operating system family and Red Hat/Rocky/CentOS Linux distribution from the Packages and Installers drop-down list.
-
Select the PostgreSQL version based on the highest version of PostgreSQL that will be used with Oracle GoldenGate.
-
Select the platform where Oracle GoldenGate will be installed, such as Red Hat Enterprise, CentOS, Scientific, or Oracle version 7.
-
Select the architecture as x86_64from the Architecture drop-down list.
This will provide the PostgreSQL setup scripts needed to install the required package(s).
-
Install the repository RPM and the
libs
module. For example:# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Install PostgreSQL libs module:
sudo yum install -y postgresql12-libs
Database Software for Capture Requirements
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. For example:
sudo yum install postgresql12-contrib
Additional Programs and Settings
Configure the LD_LIBARY_PATH
and OGG_HOME
environment variables prior to installing Oracle GoldenGate.
-
For Oracle GoldenGate installations prior to release version 19.1.0.0.220419, set the following environment variables before installing Oracle GoldenGate:
-
OGG_HOME
– The planned Oracle GoldenGate installation path. -
LD_LIBARY_PATH
– Includes the$OGG_HOME/lib
and PostgreSQLlibpq
directories.Example:
export OGG_HOME=<path_to_install_GoldenGate>
export LD_LIBRARY_PATH=$OGG_HOME/lib:/usr/pgsql-12/lib
-
-
For Oracle GoldenGate installations of release version 19.1.0.0.220419 and after, set the following environment variables before installing Oracle GoldenGate:
-
OGG_HOME
– The planned Oracle GoldenGate installation path. -
LD_LIBARY_PATH
– Includes the$OGG_HOME/lib
directory.Example:
export OGG_HOME=<path_to_install_GoldenGate>
export LD_LIBRARY_PATH=$OGG_HOME/lib
-
-
When installing Oracle GoldenGate on a remote server (one different from where the database is running), set the remote server's time and time zone to that of the source database server so that Oracle GoldenGate Extract can correctly position by time when creating the Extract with the
BEGIN
option, otherwise, position by a validLSN
value.
Parent topic: Installing Oracle GoldenGate for PostgreSQL Databases
Where to Install Oracle GoldenGate
Oracle GoldenGate for PostgreSQL must be installed on a supported operating system as per the Certification Matrix, and can be installed on the database server itself or on an application hub server, based on your preference.
Parent topic: Installing Oracle GoldenGate for PostgreSQL Databases
Installing for PostgreSQL
To install Oracle GoldenGate for your PostgreSQL system. See Installing for all Platforms.
Parent topic: Installing Oracle GoldenGate for PostgreSQL Databases
Installing the DataDirect driver for PostgreSQL
After installing Oracle GoldenGate for PostgreSQL, the Extract and Replicat processes use a DataDirect ODBC driver to connect to a PostgreSQL database. This driver is packaged with Oracle GoldenGate and needs to be installed and configured separately.
Installing for Linux
ODBCINI
variable needs to be
set.
-
For Classic Architecture, create a new session variable called
ODBCINI
and assign it the path of theodbc.ini
file, which defaults to/etc/odbc.ini
.export ODBCINI=/etc/odbc.ini
Parent topic: Installing Oracle GoldenGate for PostgreSQL Databases