Schedule Consideration for PITR

In order to be able to restore to any point in time between the latest Incremental and a previous Full or Differential backup (see the (1) area in figure Backup Level Impact in PITR Mode), it is good practice to schedule an Incremental to the same time of Full or Differential backups. The Maximum Concurrent Jobs setting on the Client and the Job resource should allow to run two jobs concurrently.

Schedule {
  Name = SCH_PostgreSQL

  Run = Full 1st sun at 23:05
  Run = Differential 2nd-5th sun at 23:05
  Run = Incremental mon-sun at 23:05
}

Without this schedule configuration, it will not be possible to restore to a specific point in time during the period between the latest Incremental backup and the next Full or Differential backup. Note that disabling Allow Duplicate Jobs prevents starting two Full backup Job at the same time.

See also

Go back to:

• PostgreSQL Server Configuration for PITR

• PostgreSQL Plugin Configuration for PITR

• PostreSQL Plugin Options in PITR Mode

• Backup Level in PITR

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.