Backing Up a PostgreSQL Database

You can perform a full backup operation or an incremental backup operation of a PostgreSQL database.

Before You Begin

For FSBasedBackupSet, verify that the archive directory is properly configured, and that archiving is working.


  1. From the navigation pane, go to Solutions > Databases > DB Instances.

    The Instances page appears.

  2. Select the row of the instance that you want to backup, and then click Backup.

    The Backup dialog box appears.

  3. Select the subclient that you want to back up, and then click Select.

    The Select backup level dialog box appears.

  4. Under Backup level, select the type of backup that you want to perform, either Full or Incremental.

  5. Click OK.

  6. Optional: To view the job details, click the job ID.


  • To associate a schedule to a subclient of a DumpBased backup set, first set the plan to none and save the changes. Then, associate the subclient to a storage policy and a schedule policy. Associating a subclient to a backup plan will only associate a storage policy, and not a schedule policy.

  • Backup operations using DumpBased backup set does not include roles and tablespace location information. This is because pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespace location information. You can save this information using pg_dumpall utility from the source.