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.

Procedure

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

    The Instances page appears.

  2. Click an instance.

    The instance page appears.

  3. In the Backup sets section, click a backup set.

    The backup set page appears.

  4. In the Database groups section, click the database group that you want to back up.

    The database group page appears.

  5. In the Backup section, click Back up now.

    The Select backup level dialog box appears.

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

  7. Click OK.

Note

  • If the database part of a 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.

Loading...