Configuring a PostgreSQL Database Instance to Run Backup Operations on a Standby Server

Updated

On this page

You can configure an instance to run backup operations from a standby server.

The following are the key features of PostgreSQL standby server backup operation:

  • Offloading the backup operations on master server for improved performance.

  • Flexibility to utilize the production server for seamless backup activity in the event of a standby server failure.

You can run a backup operation from a standby server for regular and IntelliSnap backup operations running on FSBased backup set. You cannot run a block-level backup operation from a standby server.

Note:

  • Both the master server and the standby server should be Linux computers.

  • You can perform backup and restore operations from a single master-standby unit only. You cannot perform backup operation from multiple standby servers.

  • Backup and restore operations for a standby server can be performed from PostgreSQL and EnterpriseDB version 9.2 to version 11. For versions 12 and later, you can run a standby backup for a streaming replication setup.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click an instance for which you want to run backup operations from a standby server.

    The instance page appears.

  3. On the Overview tab, click Edit.

    The Edit PostgreSQL instance dialog box appears.

  4. Move the Enable standby backup toggle key to the right, and then select the standby instance that you want to run backup operations on.

  5. Optional: To run a backup operation from the master server if standby Commvault services are not available, select the Use the master server if the standby server is not available check box.

  6. Optional: To run a log backup operation from the master server, select the Always use master for log backup check box.

  7. Click Save.