Using Parallel Jobs to Dump the PostgreSQL Database

You can use parallel jobs to dump the databases for DumpBasedBackupset subclients. To back up the database, parallel jobs use the pg_dump -j option.

Note

The pg_dump parallel job option (pg_dump with -j) is supported for PostgreSQL 9.3 and more recent versions.
If you schedule a backup on a standby node and the PostgreSQL version is older than 10, do not use parallel jobs.

For PostgreSQL agents, ndexing is enabled by default for newly installed clients in Feature Release 11.20 and more recent versions. For clients that are installed in older releases, Indexing Version 1 will be used. If you enable the Use parallel jobs to dump the database option for DumpBased BackupSet, the indexing will be upgraded to the latest version of indexing.

Before You Begin

Verify that no jobs are running for the instance.
If you have enabled IntelliSnap or block-level backups for an instance, verify that the backup copy jobs are completed.
During a pg_dump job, the backup dump size of a database can reach up to 120% of the original database size to accommodate data and metadata. Therefore, make sure that the access node staging path has enough free space to accommodate the subclient content as per the configured streams.
If a subclient is configured with n streams, you should make sure that the free storage space in the staging area is least 120% of the combined size of the n largest databases in the subclient. For example, if a subclient is configured with 2 streams and contains five databases of sizes 40 GB, 30 GB, 15 GB, 5 GB, and 1 GB, the required free space would be 120% of the two largest databases (40 GB and 30 GB), which equals 84 GB.

Procedure

From the navigation pane, go to Protect > Databases.

The database Overview page appears.
Go to Instances tab.
Click an instance.

The instance page appears.
On the Backup sets tab, click DumpBasedBackupSet.

The DumpBasedBackupSet overview page appears.
In the General tile, click Edit.

The Edit PostgreSQL Backup set dialog box appears.
Move the Use parallel jobs to dump the database toggle key to the right.
In the Number of parallel jobs box, enter the number of jobs to dump the database.

Note

pg-dump -j uses multiple database connections to connect to the database, once using the leader process and one more time for each worker job. As pg_dump opens n jobs+1 connections to the database, verify that the max_connections setting is set to the sufficient value that can accommodate all connections.
To set the staging path for backups, in the Staging path box, enter the location on the client to use for staging backups.
Click Save.