# Using Parallel Jobs to Dump the Amazon RDS for 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.

For PostgreSQL agents, indexing is enabled by default for newly installed clients in Feature Release 11.30 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 a client, indexing will be upgraded to latest version.

## Before You Begin

- Verify that no jobs are running for the instance.

- During a pg_dump job, the backup dump size of a database can reach up to 120% of the original database size to handle data and metadata. Therefore, ensure the access node staging path has enough free space to accommodate the subclient content as per the configured streams.

  If the subclient is configured with n streams, you should ensure that the free storage space on the staging area is at least 120% of the combined size of the n largest databases in the subclient. For example, a subclient configured with 2 streams and containing five databases of sizes 40GB, 30GB, 15GB, 5GB, and 1GB, the required free space would be 120% of 40 and 30 = 84GB.

- If the same access node is used for multiple cloud PostgreSQL instance backups, plan the space requirements while considering the subclient content and the number of streams.

## Procedure

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

   The database Overview page appears.

2. On the Instances tab, click the instance.

   The instance Overview page appears.

3. In the DumpBasedBackupSet details section, click Edit.

   The Edit PostgreSQL Backup set dialog box appears.

4. Move the Use parallel jobs to dump the database toggle key to the right.

5. 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. Since pg_dump opens n jobs+1 connections to the database, verify that the max_connections setting is set to a value that is sufficient to accommodate all connections.

6. To set the staging path for backups, in the Staging path box, enter the location on the client to use for staging backups.

7. Click Save.

## What to Do Next

Whenever you enable or disable parallel jobs, run a full backup on all the database groups under the DumpBasedBackupsets.

×

Loading...