Backup Level in PITR

When using PITR mode, depending on the Job level, the PostgreSQL Plugin will do the following:

  • For a Full backup, the Plugin will backup the data directory and all WAL files generated during the backup.

  • During an Incremental backup, the Plugin will force the switch of the current WAL, and will backup WAL files generated since the previous backup.

  • During a Differential backup, the Plugin will backup data files that changed since the latest Full backup, and it will backup WAL files generated during the backup.

Note

It is not possible to run two concurrent Full or Differential jobs at the same time.

Backup Level Impact in PITR Mode

Backup Level Impact in PITR Mode

where (1) is period between the latest Incremental and the new Full or Differential backup.

Note

It is recommended to visit Schedule Consideration for PITR for further information.

Note that replaying a long list of WAL files may take considerable time on a large system with lot of activities.

Go back to the PITR Configuration page.

Go back to the main PostgreSQL Configuration page page.

Go back to the Dedicated Backup Solutions page page.