The following section provides step-by-step instructions for performing your first backup:

  1. From the CommCell Browser, navigate to Client Computers |<Client> | PostgreSQL | <Instance> | DumpBasedBackupSet.

    Right-click the default subclient and click Backup.

  2. Click Full as backup type and then click Immediate.
  3. Click OK.

  4. You can track the progress of the job from the Job Controller window of the CommCell console.

  5. Once the job is complete, view the job details from the Backup History. Right-click the Subclient and select Backup History.

  6. Click OK.

  7. You can view the following details about the job by right-clicking the job:
    • Items that failed during the job
    • Items that succeeded during the job
    • Details of the job
    • Events of the job
    • Log files of the job
    • Media associated with the job

What Gets Backed Up

Dump Based Backup

  • PostgreSQL system databases
  • PostgreSQL user databases

File System Based Backup

  • PostgreSQL databases (data and logs)
  • Log files

What Does Not Get Backed Up

The following component is not backed up if using DumpBased Backup Set

  • Roles and Tablespace locations because we use pg_dump utility for DumpBased backup operation. You can back up this information using FSBased backup set.

Use the File System Agent to back up the below mentioned components

  • PostgreSQL application files
  • Operating system data.

Note: If TDE or Always Encrypted are enabled, then the following rules apply:

  • Backups are not affected.
  • If you have a storage policy that uses deduplication, then the deduplication ratio is low or non-existent.
  • If the restore destination is a different client or instance, then the database administrator must back up the encryption key, and present it to the destination instance.

Last modified: 4/27/2020 1:55:58 PM