Sample Header Ad - 728x90

Which PgBackRest policy for differential backups in PostgreSQL

1 vote
1 answer
1241 views
I set up pgBackRest and PostgreSQL configuration in two different servers. I set up with crontab one full backup a week and one differential backup a day.
0  1   *   *   0     pgbackrest --type=full --stanza=stanzaname backup  
0  1   *   *   1-6   pgbackrest --type=diff --stanza=stanzaname backup
I set up retention as below to save disk usage:
repo1-retention-full=2  
repo1-retention-diff=1
repo1-retention-archive-type=full
Is it possible to ensure PITR to cover up to 2 weeks with this retention configuration? If yes, is there a benefit to set a differential retention more than 1? Because keeping more differential backups could consume a lot of disk space.
Asked by Mika (361 rep)
May 17, 2019, 10:50 AM
Last activity: Nov 3, 2019, 01:02 PM