JavaScript must be enabled to correctly display this content
Add a Replicat for PostgreSQL
A Replicat is a process that delivers data to a target database or
technology. It reads the trail file on the target, reconstructs the DML or DDL
operations, and then applies them to the target. Learn to add a Replicat for
PostgreSQL Database, Amazon Aurora PostgreSQL, Amazon RDS for PostgreSQL, Azure Database for PostgreSQL, and Google Cloud SQL for PostgreSQL technologies.
Ensure that you follow the appropriate instructions for your deployment
version.
Add a Replicat for PostgreSQL
(21c)
Before you begin
Before you add a Replicat, create a checkpoint table to
ensure the Replicat can restart without reapplying transactions should a disruption
occur.
In the OCI GoldenGate deployment console navigation menu, click
Configuration.
In the Administration Service tab, go to the
Database tab.
Click the database connect icon for the target database.
Click Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then click
Submit.
To add a Replicat process for a PostgreSQL target in GoldenGate
21c:
In the deployment console, on the Administration service Overview page, click
Add Replicat (plus icon)
In the Add Replicat wizard, on the Replicat Type page, select one of the
following, and then click Next:
On the Replicat Options page, complete the following fields:
For Process Name, enter name, no more than 5
characters long.
(Optional) For Description, enter a brief
description to distinguish this Replicat from others.
For Intent, select the Replicat's purpose:
Disaster Recovery
Unidirectional (default)
N-Way
For Credential Domain and Credential
Alias, select the target database domain and alias, or
create a new one.
For Source, select the source of data to
process, either Trail or File.
If the source is Trail, then for Trail Name,
enter the name of the Extract trail. If the source if File, then enter
the File Name.
(Optional) If the source is Trail and you expect the trail file to be
in a location other than the default, then enter the location for
Trail Subdirectory.
For Begin, select the starting point for data
processing:
Position in Log (default)
Now
Custom Time
For Trail Sequence Number, leave the default
value or enter a transaction log sequence number.
For Trail RBA Offset, leave the default value or
enter an offset value.
For Checkpoint Table, select the checkpoint
table you created for the target deployment, or enter a two part
checkpoint table name.
Under Encryption Profile, select a profile name. If an encryption profile
wasn't created, the Local Wallet is selected by default.
Click Next.
On the Parameter File page, add parameters to further configure the Replicat
process.
Note:
GoldenGate uses Greenwich
Mean Time (GMT) by default. Use SETENV to override the default setting. For
example:
Click Create and Run. If you click
Create, then you can manually start the Replicat
later from the Administration Service Overview page.
You return to the Administration Service Overview page where you can view the
creation of the Replicat process and access Replicat Actions.
Add a Replicat for PostgreSQL (23ai)
Before you begin
Ensure that you add a Checkpoint table for the
Replicat to restart without recapturing reapplying transactions should a discruption
occur.
In the OCI GoldenGate deployment console, expand DB
Connections, and select your target database.
Click Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then click
Submit.
To add a Replicat for PostgreSQL in GoldenGate 23ai:
In the OCI GoldenGate deployment console, on the Administration Service Home page, click
Add Replicat (plus icon).
In the Add Replicat panel, on the Replicat Information page,
complete the fields as needed, and then click Next:
Select a Replicat Type:
Parallel Replicat
If selected, select a Parallel Replicat Type, either Nonintegrated or
Integrated.
Integrated Replicat
Nonintegrated Replicat
Coordinated Replicat
Enter a Process Name, no more than 5 characters long.
Enter a Description, to help distinguish this process from
others.
On the Replicat Options page, complete the fields as needed, and
then click Next:
Replicat Trail:
Enter a Name.
Enter a Subdirectory, if you expect the Trail file to be
in a location other than the default.
Select an Encryption profile. If an encryption profile
wasn't created, the Local Wallet is selected by default.
Target Credentials:
Select a Domain.
Select an Alias within the specified Domain.
Select a Checkpoint Table. Leave the default selection or
select the checkpoint table you created for the target deployment.
Select the Max Threads Number (Coordinated Replicats
only).
For Begin, select the starting point for data
processing:
Position in Log (default)
Now
Custom Time
Trail Position:
Enter the Sequence Number.
Enter the RBA Offset.
On the Managed Options page, complete the optional fields as
needed, and then click Next:
Select a Profile Name.
Enable Critical to deployment health.
On the Parameter File page, you can add parameters to further
configure your Replicat. For example:
table source.table1;
Note:
GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the
default setting for this Replicat process. This change doesn't apply to deployments.
For example:
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
Click Create and Run. If you click
Create, then you can manually start the Replicat later from the
Administration Service Home page.
Oracle customer access to and use of Oracle support
services will be pursuant to the terms and conditions specified in their Oracle
order for the applicable services.