Recovery You Can Prove · Kai London
PostgreSQL High Availability and Recovery Validation: Prove Failover, Restore and Upgrade Procedures Under Failure
A PostgreSQL cluster never failed over is an assumption. Can you prove your recovery works?
A PostgreSQL cluster that has never been failed over, restored or upgraded under pressure is an assumption, not a recovery capability. This independent practitioner reference lets database engineers and operations teams prove that failover, restore and major-upgrade procedures work, with evidence gathered under controlled failure.
Part I is the practitioner guide, covering recovery objectives, reference topologies, backups, point-in-time recovery, replication and failover. Part II is the field toolkit: a reference lab built from Patroni and pgBackRest, failure-injection and recovery drills, scheduled validation scripts, extended case studies, and annotated templates. Part III is reference and practice, with workbooks, tabletop exercises and templates for runbooks, reports and handover. Part IV is an evidence casebook of worked cases, and Appendix A provides checklists.
Specific topics include point-in-time recovery from archived WAL, streaming replication and replica rebuild, fencing and failover behaviour, major version upgrades rehearsed on restored clones, detection of corruption, and monitoring of backup freshness. The recovery proof chapter and a worked case show how to turn test results into records that others can review.
It is written for database administrators, site reliability engineers, platform and infrastructure leads, auditors, and managers accountable for PostgreSQL recovery objectives.
Every chapter is built for working professionals: a real headline, a dramatised boardroom scene, decision tables, worked examples with expected results, the evidence to keep, a checklist, the board question and a self-test. The book closes with a capstone assessment, consolidated checklists, model answers, a standards crosswalk, a certification domain map for CISSP, CISM, CRISC and CISA, and a full index.
Professor Kai London