7 min read
PITR lets you restore the database to any moment within your retention window. The feature is well-documented; the operational reality is messier.
PostgreSQL Topic Archive
Backups and Durability PostgreSQL Articles
Backups, restores, PITR, archive gaps, and recovery drills for PostgreSQL.
6 min read
Most teams have backups. Most teams have never restored from one. The first time you test, you find out the backup was missing something.
6 min read
Logical and physical backups solve different problems. Most teams need both, but only have one. Here is the actual decision framework.
5 min read
WAL accumulates fast. The retention policy is a tradeoff between PITR window and storage cost. Here is how I think about it.
13 min read
Backups only matter if restore is rehearsed. The real work is choosing RPO/RTO, preserving WAL, testing restores, and knowing what data you can afford to lose.