Enabling Backups for Global Objects in PostgreSQL Databases

You can back up information about global objects (such as roles) in a PostgreSQL database. To back up global objects, the Commvault software uses the pg_dumpall utility with -c and -s options.

It is supported only for PostgreSQL agents with indexing enabled. For PostgreSQL agents, this is enabled by default for newly installed clients in Feature Release 11.30 and more recent versions. F

Procedure

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

   The database Overview page appears.

2. Go to Instances tab.

3. Click an instance.

   The instance page appears.

4. On the Backup sets tab, click DumpBasedBackupSet.

   The DumpBasedBackupSet overview page appears.

5. In the General tile, click Edit.

   The Edit PostgreSQL Backup set dialog box appears.

6. Select the Back up global objects check box.

7. Click Save.