Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Oracle GoldenGate PostgreSQL Capture is Available now

Nisharahmed Soneji
Senior Principal Product Manager, Oracle GoldenGate

Oracle Database Product Management is excited to announce the general availability of Oracle GoldenGate PostgreSQL Capture support. The GoldenGate PostgreSQL Delivery has been supported since GoldenGate 12.1 release and allowing users to replicate the data from GoldenGate supported heterogeneous databases to PostgreSQL Databases. In addition to GoldenGate PostgreSQL Delivery, now it supports the capturing of data from PostgreSQL database versions 10 and above. 

It also supports the capturing of data from Amazon PostgreSQL RDS and Amazon PostgreSQL Aurora and helps you replicate the data into Oracle autonomous database which is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. Unlike a conventional database, an autonomous database performs all these tasks and more without human intervention.

You may host the GoldenGate for PostgreSQL on OCI Cloud Instance and remotely capture the data from Amazon PostgreSQL RDS and Amazon PostgreSQL Aurora to replicate the data into autonomous databases.

As GoldenGate is true Heterogeneous Database replication tool, the GoldenGate PostgreSQL follows the same tradition and allows capturing data from PostgreSQL database (including AWS RDS and Aurora) to be replicated into GoldenGate supported databases including Big Data, No SQL and Cloud targets and vice-versa.

In the hybrid cloud replication, it is must to support the multiple cloud vendors and not just one cloud vendor to restrict the usage of functionality. Hence, GoldenGate PostgreSQL supports remote capture and delivery to & from PostgreSQL database to support the multiple cloud vendors like AWS PostgreSQL services, Oracle Autonomous Database services and in future it will expand its scope of support to other cloud vendors. The Cross-endian remote Extract allows remote capture of on-premises PostgreSQL databases for easier migration to the cloud. You may capture data remotely using cross-endian extract from PostgreSQL database running on Solaris, HPUX, Windows, AIX and any PostgreSQL supported platforms. 

Benefits of Oracle GoldenGate PostgreSQL Capture include:

  • Initial Load to sync data from and to PostgreSQL database
  • PostgreSQL Database Version 10 & above supported for Capture
  • Supports the Linux platform for the native build
  • Majority of data types including CLOB and BLOB can be used to captured and delivered to
  • SSL enabled PostgreSQL database supported for capture and delivery
  • Globalization support for Data and objects
  • Managing multiple replication slots or data stream to increase the capture throughput
  • GoldenGate PostgreSQL can co-exists with native replication tool
  • Heart-beat table supported for measuring end to end lag
  • Coordinated replicat & BatchSQL support for better replication throughput 
  • CDR (Conflict Detection & Resolution) to resolve conflicts while replicating data

Documentation and Certification Details:

Join the discussion

Comments ( 1 )
  • Eric Yen Thursday, July 16, 2020
    Thank you. Can’t wait to try it out.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.