Top
Enterprise Postgres 17 Cluster Operation Guide(Database Multiplexing)

3.5 Manually Disconnecting the Standby Server

The procedure to perform disconnection of the standby server differs depending on whether the automatic switch/disconnection is enabled or disabled.

If automatic switch/disconnection is enabled

Execute the mc_ctl command in stop mode on the standby server.

Example)
$ mc_ctl stop -M /mcdir/inst1
If automatic switch/disconnection is disabled
  1. Execute the mc_ctl command in stop mode on the standby server.

    Example)
    $ mc_ctl stop -M /mcdir/inst1
  2. Comment out the synchronous_standby_names parameter in the postgresql.conf file on the primary server. If you have set the synchronized_standby_slots parameter, comment out the synchronized_standby_slots parameter as well.

  3. Execute the pg_ctl command in reload mode on the primary server.

    Example)
    $ pg_ctl reload -D /database/inst1

Point

If automatic start and stop of Mirroring Controller has been configured using systemd, do not use the mc_ctl command, but instead use the systemctl command. Refer to "2.12 Setting Automatic Start and Stop of Mirroring Controller and Multiplexed Instances" for details.