Posts

Showing posts from December, 2022

configure Oracle Golden Gate between Oracle - Postgres

 Source: Oracle 19c  Target: PostgreSQL 15 Golden Gate Version: Golden Gate 19.1 for Oracle (Source), Golden Gate 19.1 for PostgreSQL Database (Target ). Source Hostname: oracle  Target Hostname: postgres  Run below commands on Target Postgres database by root , postgres and Oracle users :-  install postgress dev binary :- rpm -ivh libtermcap-devel rpm -ivh readline-devel rpm -ivh gcc* rpm -ivh zlib rpm -ivh postgresql93-odbc yum search postgre | grep odbc give full permission to /tmp folder ( chmod -R 777 /tmp) download and install postgress 15  https://www.postgresql.org/ftp/source/v15.1/ postgresql-15.1.tar.gz tar -xvf above file  ./configure mkdir build_dir cd build_dir /path/to/source/tree/configure [options go there] make make install make install-docs adduser postgres mkdir /u02/pgsql/data chown postgres /u02/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data You can now start the database server using: /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/d