Loading...

Performing a Block-Level Synthetic Full Backup for PostgreSQL Databases

A block-level synthetic full backup is a synthesized backup that is created from the most recent block-level full backup and the subsequent log only backups. A synthetic full backup does not transfer data from a client computer to the backup media. Therefore, it does not use any resources on the client computer. You can back up the synthetic full data on a storage policy with a single drive or data path.

Best practice: Run a log only backup either before or after a synthetic full backup.

  • When you run a log only backup before a synthetic full backup, any new or recently changed data is included in the synthetic full backup.
  • When you run a log only backup after a synthetic full backup, any new or recently changed data that was not included in the synthetic full is included in a log-only backup.

Procedure

  1. From the CommCell Browser, expand Client Computers > Client > PostgreSQL > Instance > FSBasedBackupSet.
  2. Right-click the subclient that you configured for performing a block-level backup, and then click Backup.

    The Backup Options dialog box is displayed.

  3. Select Synthetic Full as the backup type.
  4. In the Job Initiation section, specify whether you want to run the backup job immediately or to schedule it.
  5. Click OK.

Result

The Job Controller displays the synthetic full backup job as Synthetic Full.

You can view detailed information about a backup job, such as the objects that were backed up or the backup option that was used. For more information, see Viewing the Details of a Block-Level Backup Job.

Last modified: 3/1/2018 8:04:20 PM