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. For more information, see Configuring the PostgreSQL Archive Log Directory.

From the navigation pane, go to Protect > Databases.

The database overview page appears.
Go to the Instances page.
Click an instance.

The instance Overview page appears.
On the Backup sets section, click a backup set.

The backup set Overview page appears.
On the Database groups tab, if you click the Action button in the row for the database instance to restore, and then click Backup.

Alternatively, you can click a database group and select the Backup option from the database group overview page.

The Backup options dialog box opens.
Under Backup level, select the type of backup that you want to perform, either Full or Incremental.
Click Submit.

Note

If a database part of the database group (other than default) is renamed or removed, the backup content for the database group needs to be updated manually. The old database will not be removed automatically.
By default, backup operations using DumpBased backup set do not include location information for roles and tablespaces. This is because pg_dump utility that is used to perform DumpBased backup operation does not back up roles and tablespaces. To save this information using the pg_dumpall utility, enable backups for global objects in PostgreSQL databases.