PostgreSQL
posts (3)
- Recovery from the Ground Up: Rollback, PITR, and Returning After Failure4/5
PITR for One Tenant: Restoring One Database
A simple PITR example in a multi-tenant system: one tenant has one database, so we restore only that database instead of rolling back the whole production…
- Recovery from the Ground Up: Rollback, PITR, and Returning After Failure3/5
Whole-Server PITR: Restore Is Only the Beginning
Whole-server PITR does not end when the database is restored. We still need to freeze writes, validate state, switch traffic, and consciously abandon or move…
- series · 5 parts
Recovery from the Ground Up: Rollback, PITR, and Returning After Failure
Recovery does not start with a large disaster recovery plan. It starts with a simple question: what exactly do we need to return to, and how much can we lose?