Loading...

Configuring Master and Standby Server Instances

Configure the master server instance to add a standby server instance on which you want to offload backup and restore operations.

Before You Begin

  1. Install the PostgreSQL agent, both on the master server and the standby server.

    For more information, see Deployment - PostgreSQL Agent.

  2. Create a PostgreSQL instance, both on the master server and the standby server.
  3. For streaming replication, configure the archive command. It will be used to provide a continuous backup support in case of a failover, when the standby server role changes to a master server.

Procedure

  1. From the CommCell Browser, expand Client Computers > master client > PostgreSQL.
  2. Right-click the instance, and then click Properties.

    The Properties of PostgreSQL Instance dialog box appears.

  3. On the Standby Settings tab, select options for standby server support:
    1. Select the Enable Standby Backup check box.
    2. From the Standby Instance list, select an instance on the standby server on which you want to offload backup and restore operations.
    3. Optional: To run a backup operation from the master server if standby server is not available, select the Use master if standby is unavailable check box.
    4. Optional: To run a log backup operation from the master server, select the Always use master for log backup check box.
  4. Click OK.

Last modified: 5/21/2018 6:41:59 AM