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
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
Click an instance for which you want to run backup operations from a standby server.
The instance page appears.
-
On the Overview tab, click Edit.
The Edit PostgreSQL instance dialog box appears.
-
Move the Enable standby backup toggle key to the right, and then select the standby instance that you want to run backup operations on.
-
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.
-
Optional: To run a log backup operation from the master server, select the Always use master for log backup check box.
-
Click Save.