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 Version 2 enabled. For PostgreSQL agents, the Indexing version 2 is enabled by default for newly installed clients in Feature Release 11.20 and more recent versions. For more information about how to upgrade client to Indexing Version 2, refer to Migration of Clients to Indexing Version 2.

Procedure

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

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. In the Backup sets section, click DumpBasedBackupSet.

    The DumpBasedBackupSet page appears.

  4. In the General section, click Edit.

    The Edit PostgreSQL backupset dialog box appears.

  5. Select the Back up global objects check box.

  6. Click Save.

Loading...