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:
Documentation and Certification Details: