Add a PostgreSQL DB System to a Disaster Recovery Protection Group

Learn how to add a PostgreSQL DB System to a Disaster Recovery (DR) Protection Group.

Before you begin, ensure that the primary PostgreSQL DB System and its warm standby are configured and replication is healthy.

1. From the Resource type menu, select PostgreSQL DB System.
2. From the PostgreSQL DB System in compartment menu, select the compartment containing the PostgreSQL DB System.
3. From the PostgreSQL DB System menu, select the PostgreSQL DB System that you want to add.
4. From the Peer PostgreSQL DB System in compartment menu, select the compartment containing the peer PostgreSQL DB System.

5. From the Peer PostgreSQL DB System menu, select the peer PostgreSQL DB System.

   Note:

   When adding a member to the primary DR protection group, select the primary PostgreSQL DB System and its warm standby as the peer. Similarly, when adding a member to the standby DR protection group, select the warm standby PostgreSQL DB System and its primary as the peer.

6. Click Add to add the PostgreSQL DB System to the DR protection group.

   The PostgreSQL DB System is added to the DR protection group.

7. Click Publish changes to publish the updated DR protection group configuration.

   The changes are published to the DR protection group.

Related Topics

• OCI Database with PostgreSQL
• Replication with Warm Standby