# PostgreSQL Restore Drill Checklist

## Scope

- Drill owner:
- Date and timezone:
- Source cluster:
- Failure scenario:
- Target RPO:
- Target RTO:
- Selected backup:
- Selected recovery target:

## Isolation and safety

- [ ] Restore target is isolated from production clients.
- [ ] Production data directory is not mounted.
- [ ] Outbound jobs, email, webhooks, and CDC are disabled.
- [ ] Credentials and encryption keys are available through approved paths.
- [ ] Storage capacity is sufficient.

## Timeline

| Milestone | Timestamp | Evidence |
|---|---|---|
| Incident declared | | |
| Infrastructure ready | | |
| Backup selected | | |
| File restore complete | | |
| WAL replay complete | | |
| Database validation complete | | |
| Application smoke complete | | |

## Validation

- [ ] PostgreSQL starts without unexpected recovery errors.
- [ ] Expected timeline, LSN, and timestamp are confirmed.
- [ ] Required databases, roles, extensions, and tablespaces exist.
- [ ] Critical row counts and business invariants pass.
- [ ] Application smoke queries pass.
- [ ] Actual RPO and RTO are calculated.

## Follow-up

- Gaps found:
- Owners:
- Due dates:
- Runbook changes:
- Next drill scenario: