If the system behavior is unstable, for example there are insufficient system resources such as available memory or free disk space, automatic disconnection using Mirroring Controller may not be possible.
In this case, perform the following procedure to disconnect the primary server manually.
On the standby server, execute the mc_ctl command in stop mode with the -e option specified.
Example)
$ mc_ctl stop -M /mcdir/inst1 -e
On the primary server, comment out the synchronous_standby_names parameter in the postgresql.conf file.
Example)
: # synchronous_standby_names = 'standby1 '
Execute the pg_ctl command in reload mode on the primary server.
Example)
$ pg_ctl reload -D /database/inst1
See
Refer to "pg_ctl" in Reference for information on the command.
See
Recovery to database multiplexing mode
Refer to "8.1.2.2 Rebuild the Standby Server" for information on recovery to database multiplexing mode.