Incremental Backup
summary
Implements a block‑level incremental backup in PostgreSQL 17 that decides per 8KB blocks which pages to copy, using a background WAL summarizer that emits tiny summary files so restores read only needed data. Requires setting summarize_wal=on (default keep time 10 days), takes incrementals with pg_basebackup --incremental pointing at a prior manifest, verifies with pg_verifybackup and reconstructs full output with pg_combined_backup. Works in testing, supports replicas, tar/cloud read and in‑place consolidation are listed as future work.
AI-written summary · about
chapters (8)
- 0:00Introduction and overview
- 3:00Motivation and disclaimers
- 5:56Configuration and basic usage
- 15:29Architectural design
- 26:49Restoring an incremental backup
- 34:24Recovery requirements
- 39:20Advanced backup strategies
- 42:24Future work and conclusion
related talks
18mIncremental Backup in PostgreSQL
41mDemystifying Incremental Backups in the PostgreSQL Ecosystem
39mIncremental Backups in PostgreSQL
43mPostgreSQL 17 and beyond
51mHeavy Duty Backup w/PgBackRest
49mWhat can't pgBackRest do for you?
41mpgBackRest: Elevating PostgreSQL Backup Game
49mTools for Creating PostgreSQL Backups