1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. PostgreSQL
  5. Understanding What's Supported for PostgreSQL
  6. Supported Databases

Supported Databases

The following are supported databases and limitations for Oracle GoldenGate for PostgreSQL:

  • Only user databases are supported for capture and delivery.

  • Oracle GoldenGate does not support capture from archived logs.

  • Capture and delivery are not supported against replica, standby databases.

  • High Availability:

    • Oracle GoldenGate Extract does not support seamless role transitioning from a primary to a secondary Extract with PostgreSQL high availability configurations. However, manual procedural operations could be followed to provide continuity from the new primary Extract.

    • For more information, see the details available in the my Oracle Support note, Oracle GoldenGate Procedures for PostgreSQL HA Failover (Doc ID 2818379.1).