Incremental backup overview

Last Updated : Jul 20, 2022 |

Using incremental backup, also called PgBackRest backup, you can schedule a daily automatic backup of the Avaya Analytics™ Postgres Cluster from the previous backup taken till the current day. Incremental database backup is compressed and stored on the pre-configured NFS.

Note:

Avaya Analytics™ Postgres Cluster includes both Avaya Analytics™ data and Historical Reporting custom report data.

The default schedule of incremental backup is the following:

  • Base backup: It is a full database backup. By default, the backup is scheduled every Sunday at 04:00 a.m.

  • Incremental backup: It is a backup taken based on the latest base backup. By default, the backup is scheduled daily at 00:00 a.m.

Important:

Incremental backups are based on the local system timezone.

Note:

Incremental backups (pgBackRest) and Remote backups (pgdump) are not interoperable.

Retention Policy

The retention policy is applicable by default on incremental backups. Retention policy enforces below:

  • Up to one full backup can be stored on BackRest PV. When a new full backup is stored, the oldest backup is deleted from the NFS.

  • There is no limit for incremental backup storage. Incremental backups cannot be independently deleted because all prior incremental backups (back to the last full backup) are needed to reconstruct the backup. For example, if you have seven incremental backups in a row, you cannot delete the first four.

  • When a full backup is deleted, all the incremental backups based on this full backup is automatically deleted.

  • There is no retention policy for full remote backups, as they are stored off the cluster.

    Note:

    There is an exception to the retention policy. When performing a restore, a backup is created at the end of the restore process. This backup is used for restoring the replica database and is a part of the pgBackRest operation. When this backup is created, it does not have any retention setting configured to not delete the oldest backup.

Related information
Avaya Analytics backups