Backups and recovery · 8 min read
How to write a restore runbook you can follow at 3 a.m.
A fill-in restore runbook template for one VPS covering who does what, the order of steps, RTO and RPO in plain words, and how to drill it until it works.
Posts tagged “recovery”
5 articles about recovery.
Postgres and data · 12 min read
Restore PostgreSQL to a timestamp with recovery_target_time
Step by step PITR on PostgreSQL 15 to 17 with recovery.signal, restore_command and recovery_target_time, plus timelines and how to verify the result.
Postgres and data · 10 min read
How much data a disk failure costs with WAL archiving
We killed a PostgreSQL server mid-write and restored from the archive alone, so you can choose archive_timeout from measured loss instead of guessing.
Postgres and data · 10 min read
pg_dump vs physical backup vs PITR: which to use
A decision guide to logical dumps, pg_basebackup and point-in-time recovery, with a comparison table and recommendations by database size and RPO.
Backups and recovery · 8 min read
I destroyed my server on purpose and timed the recovery
Script a disaster-recovery drill for one VPS. Destroy the server, rebuild from restic, check the data, and see timings and five failures it found.