Sample deliverable · Data & Databases
Sample cut-over runbook: PostgreSQL major upgrade with blue/green
A step-by-step runbook excerpt with timings, owners, checks and the rollback path.
Sample / template. Fictional systems and figures that show the format and depth of what you receive. Not a client deliverable.
System: reporting-db (fictional), Amazon RDS for PostgreSQL 14 to 16 · Method: blue/green deployment · Rehearsed: twice, switchover measured at under 1 minute in rehearsal
Roles
- Change lead: runs the runbook and calls go/no-go
- Application owner: runs smoke tests
- Observer: watches dashboards and records timings
Go/no-go criteria
- Green environment in sync, replica lag under 1 second
- Latest snapshot under 1 hour old
- Application owner and change lead present
Steps
| Time | Step | Owner | Check |
|---|---|---|---|
| T-24h | Freeze schema changes; confirm change approval | Change lead | Approval recorded |
| T-60m | Take manual snapshot of blue | Change lead | Snapshot available |
| T-30m | Confirm green parameters, extensions and replica lag | Change lead | Lag under 1s |
| T-10m | Go/no-go call | All | Criteria met |
| T-0 | Start switchover | Change lead | Event log shows switchover |
| T+5m | Run smoke tests and data checks | App owner | All pass |
| T+15m | Compare latency and errors with baseline | Observer | Within agreed limits |
| T+30m | Declare complete or roll back | Change lead | Decision recorded |
Rollback
If checks fail before T+30m, switch traffic back to the retained blue environment using the rehearsed steps (measured in rehearsal), then restore from the T-60m snapshot only if blue is unusable. Rollback was rehearsed and timed before the change was approved.
After the change
- Run ANALYZE on large tables and watch query plans for 48 hours
- Keep blue for 7 days, then delete after sign-off
- Update documentation and the upgrade calendar
Want this for your systems?
Every paid assessment ends in a document like this, with your real systems, risks and a fixed quote. The fee is credited to the project.