Enabling Backups for Global Objects in PostgreSQL Databases on Alibaba Cloud ApsaraDB RDS

You can back up global objects (such as roles) in a PostgreSQL database. To back up global objects, the Commvault software uses the pg_dumpall utility with -c, -g, --no-role-passwords, and -s options as per the requirement.

Procedure

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

   The database Overview page appears.

2. Go to the Instances tab.

3. Click the instance.

   The instance Overview page appears.

4. In the DumpBasedBackupSet details section, click Edit.

   The Edit PostgreSQL Backupset dialog box appears.

5. If you move Use parallel jobs to dump the database toggle key to right, you have to enter the following details:

   1. In the Number of parallel jobs box, enter the number of jobs to dump the database.

   2. In the Staging path box, enter the path to stage the data.

6. Select the Back up global objects check box.

7. Click Save.