Top
Enterprise Postgres 17 SP1 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.