Top
Enterprise Postgres 16 Operation Guide

10.3 Converting an Asynchronous Replication to Synchronous

You can convert an asynchronous standby instance to a synchronous standby instance.

Converting an Asynchronous standby instance to Synchronous can cause the master instance to queue the incoming transactions until the standby instance is ready. For this reason, it is recommended that this operation be performed during a scheduled maintenance period.

When adding a synchronous standby instance, Fujitsu Enterprise Postgres will only keep the first entry in [Synchronous standby names] in synchronous state.

Follow the procedure below to convert an Asynchronous standby instance to Synchronous.

  1. In the [Instances] tab, select the master instance of the relevant cluster.

  2. Click .

  3. In the [Streaming replication] section, edit the value for [Synchronous standby names].

    • Add the "Application name" of the standby instance you want to be in Synchronous mode.

  4. Click .

  5. Select the master instance and click .

  6. Select the standby instance. [Instance type] will now show the updated status.

See

To learn more about the differences between synchronous and asynchronous standby modes and their behavior, refer to "Streaming Replication" in "High Availability, Load Balancing, and Replication" in the PostgreSQL Documentation.