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.

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.

Before You Begin

Verify that you have at least two media drives associated with the storage policy of the subclient that you configured for performing a block-level backup. You need at least two media drives, because synthetic full backups read (back up) and write (restore) simultaneously on two media drives.

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.