Performing PostgreSQL Log Only Backup Operations

Updated

Log backups are useful when you want to recover database transactions that have been lost due to an operating system or disk failure. You can apply these logs to an online backup in order to recover a database.

Backups for FSBased backupsets include both data and logs. However, you can run a log only backup. Prior to running log only backups ensure that the PostgreSQL database is in ARCHIVE mode.

Procedure

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

  2. Right-click the <Subclient> and click Backup.

  3. Select Incremental as the backup type, and then click Immediate.

  4. Click OK.

You can track the progress of the job from the Job Controller. When the backup job has completed, the Job Controller displays Completed.

Was this page helpful?