Configuring Subclients for Greenplum Database Backups

The default Greenplum subclient contains all the segment server databases in the content.

You can create separate subclients when you have Greenplum databases that need to be backed up on separate schedules.

Best Practice: To prevent the segment hosts from waiting for resources, set the number of data readers (Advanced Subclient Properties dialog box, Performance tab, Number of Data Readers) to a value that is one more than the number of segments hosts that are in the Greenplum Database system.

Before You Begin

• Add the Greenplum Pseudo-Client.

Procedure

1. From the CommCell Browser, expand Client Computers > client > Greenplum.

2. Right-click the instance, point to All Tasks and then click New Subclient.

   The Create New Subclient dialog box is displayed.

3. On the General tab, in the Subclient Name box, enter a name for the subclient.

4. On the Content tab, click Add Paths, and then specify the database to back up.

   For example, /database1.

5. On the Storage Device tab, select the storage policy to use for backups from the Data Storage Policy list.

6. Click Advanced.

   The Advanced Subclient Properties dialog box is displayed.

7. In the Number of Data Readers box, type a value that is one more than the number of segments hosts that are in the Greenplum Database system.

8. Optional: Select the subclient options.

   Run scripts before or after the backup

   You can choose to run the post-process script even if the backup job failed.

   On the Pre/Post tab:

   1. In the Pre-Backup Command box, type the full path name for the script.

   2. In the PostBackup Command box, type the full path name for the script.

   3. To run the post backup process regardless of the job outcome, select the Run Post Process for all attempts check box.

9. Click OK to close the Advanced Subclient Properties dialog box.

10. Click OK to close the Create New Subclient dialog box.

What to Do Next

• Perform a backup.