Add a Replicat for PostgreSQL

Learn to add a Replicat for PostgreSQL Database, Extract for PostgreSQL Database, OCI Database with PostgreSQL, Amazon Aurora PostgreSQL, Amazon RDS for PostgreSQL, Azure Database for PostgreSQL, Azure Cosmos DB for PostgreSQL, and Google Cloud SQL for PostgreSQL, EDB Postgres Advanced Server, and YugabyteDB in OCI GoldenGate.

Ensure that you follow the appropriate instructions for your deployment version.

Add a Replicat for PostgreSQL (26ai)

Before you begin

Ensure that you add a Checkpoint table for the Replicat to restart without recapturing reapplying transactions should a disruption occur.

1. In the OCI GoldenGate deployment console navigation menu, expand DB Connections, and select your target database.

2. Select Add Checkpoint (plus icon).

3. For Checkpoint Table, enter the target schema name, and then select Submit.

Add the Replicat

1. In the OCI GoldenGate deployment console navigation menu, select Replicats.

2. On the Replicats page, select Add Replicat (plus icon).

3. The Add Replicat form consists of four pages. Complete the form as needed:

   1. On the Replicat Information page:

      1. Select a Replicat type:

         • Classic Replicat

         • Coordinated Replicat

         • Parallel Replicat

         Learn about different Replicat types.

      2. Select Next.

   2. On the Replicat Options page:

      1. Enter the Replicat trail details:

         • Name (can only be two characters)

         • Subdirectory

      2. Select the Target Credentials:

         • Domain

         • Alias

         • Checkpoint Table

         • (Optional) When to Begin

      3. Enter the Trail Position Sequence Number and RBA Offset.

      4. Select Next.

   3. On the Managed Options page, complete the optional fields as needed:

      1. Select a Profile Name.

      2. Enable Critical to deployment health.

      3. Enable Auto Start.

      4. Enable Auto Restart.

      5. Select Next.

   4. On the Parameter File page, you can configure how the Replicat maps the source and target tables. For example:

      MAP table.*, TARGET table.*;

4. Select Create and Run to start the Replicat. If you select Create, you can manually start the Replicat later on the Replicats page.

You return to the Replicats page, where you can select the Replicat to view its details.

Add a Replicat for PostgreSQL (21c)

Before you begin

Create a checkpoint table to ensure the Replicat can restart without reapplying transactions should a disruption occur.

1. In the OCI GoldenGate deployment console navigation menu, select Configuration.

2. On the Database tab, select the database connect icon for the target database.

3. Select Add Checkpoint (plus icon).

4. For Checkpoint Table, enter the target schema name, and then select Submit.

Add the Replicat

1. In the deployment console, on the Administration service Overview page, select Add Replicat (plus icon)

2. In the Add Replicat wizard, on the Replicat Type page, select one of the following, and then select Next:

   • Classic Replicat

   • Coordinated Replicat

   • Parallel Replicat

   Learn more about different Replicat types.

3. On the Replicat Options page, complete the following fields, and then select Next:

   1. For Process Name, enter name, no more than 5 characters long.

   2. (Optional) For Description, enter a brief description to distinguish this Replicat from others.

   3. For Intent, select the Replicat's purpose:

      • Disaster Recovery

      • Unidirectional (default)

      • N-Way

   4. For Credential Domain and Credential Alias, select the target database domain and alias, or create a new one.

   5. For Source, select the source of data to process, either Trail or File.

   6. 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.

   7. (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.

   8. For Begin, select the starting point for data processing:

      • Position in Log (default)

      • Now

      • Custom Time

   9. For Trail Sequence Number, leave the default value or enter a transaction log sequence number.

   10. For Trail RBA Offset, leave the default value or enter an offset value.

   11. For Checkpoint Table, select the checkpoint table you created for the target deployment, or enter a two part checkpoint table name.

4. Under Encryption Profile, select a profile name. If an encryption profile wasn't created, the Local Wallet is selected by default.

5. On the Parameter File page, add parameters to further configure the Replicat process.

   table source.table1;

   Note:

   GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for the Replicat. This change doesn’t apply to deployments. For example:

   setenv (TZ="US/Eastern")
   setenv (TZ="GMT+5")

6. Select Create and Run. If you select 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.