Restore your backups!
No video of the event yet, sorry!
How do Postgres backups work? What's really going on behind the friendly façade of Barman or pgBackRest or WAL-E? What's in this base backup, and how long is it going to take for your database to be up again?
This talk is an in-depth look at the mechanisms in Postgres to take backups, and how restoring from a backup actually works. Take a fresh look at checkpoints, consistency, point-in-time recovery, recovery targets, and other features. No matter which backup program you use, an understanding of the underlying concepts will help you avoid nasty surprises in a disaster-recovery situation.
- 45 min
- PGConf India, 2019
- Database Administration