PostgreSQL: Extract Considerations for Remote Deployment
For a remote deployment, the source database and Oracle GoldenGate are installed on separate servers. Remote deployments are the only option available for supporting cloud databases, such as Azure for PostgreSQL or Amazon Aurora PostgreSQL.
For remote deployments, operating system endianness between the database server and Oracle GoldenGate server need to be the same.
Server time and time zones of the Oracle GoldenGate server should be synchronized with that of the database server. If this is not possible, then positioning of an Extract when creating or altering one will need to be done by LSN.
In remote capture use cases, using SQLEXEC
may introduce
additional latency, as the SQLEXEC
operation must be done serially for
each record that the Extract processes. If special filtering that would require a
SQLEXEC
is done by a remote hub Extract and the performance impact
is too severe, it may become necessary to move the Extract process closer to the source
database.
With remote deployments, low network latency is important, and it is recommended that the network latency between the Oracle GoldenGate server and the source database server be less than 1 millisecond.