PostgreSQL Disaster Recovery Fundamentals

on YouTube ↗22m

" summary

Claims that replication alone is not enough and a practical DR plan combines physical base backups, WAL archiving and tested restores; demonstrates using pg_basebackup plus WAL replay for Point-in-Time Recovery and shows pgBackRest for differential/incremental backups to avoid losing 12+ hours (example: nightly 1:00 a.m. full backup then 1:00 p.m. data loss). Explains streaming replication with automated failover via Patroni, routine restore testing, alerts, and the emergency steps: stop writes, find failure point, apply WAL, verify integrity.

AI-written summary · about

" chapters (11)

1. 0:00PostgreSQL disaster recovery intro
2. 1:28Why recovery plans matter
3. 5:01Risks, RTO and RPO
4. 7:28PostgreSQL backup types
5. 9:39High availability via replication
6. 11:10Monitoring for recovery
7. 12:56Testing backups and docs
8. 15:46Backup strategies and PITR
9. 17:56Disaster recovery walkthrough
10. 20:46Root cause analysis
11. 21:30Q&A

" related talks

• 56mPostgreSQL Backup StrategiesMagnus Hagander · Postgres Open 2012
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 48mCTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQLSakshi Nasha · PostgreSQL Conference Europe 2025
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 10mBackups Are Good, Replicas Are Better: Demystifying Replication on PostgreSQLDan FAUDEMER · DevFest Toulouse 2024
• 50mPostgreSQL Backup and Recovery MethodsKevin Kempter · PostgresOpen 2013
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013