Backup and Restore Service  ·  View 14 of 26  ·  5 · Runtime

Point-in-Time Restore — Side by Side, Tier 1 PostgreSQL

The path a restore takes from request to a promoted copy, and the same path the daily rehearsal uses.

Editable source SVG draw.io All views
On-call SRE Platform API Restore orchestrator Catalogue OpenBao Custody A Target host 1. restore orders @ 14:03:27, side by side 2. OPA: owner team · target class ≥ source 3. start RestoreWorkflow 4. recovery point → base + log range 5. incr 14:00 · WAL to 14:04 · no gap 6. extend retain-until +7 d 7. unwrap data key · restore SVID 8. key for class: confidential 9. pgbackrest restore --type=time 10. 32 parallel GETs 11. replay ≤ 1 h of WAL 12. promoted at target time 13. restore_run · duration 14. ready · ETA was tracked live Point-in-Time Restore — Side by Side, Tier 1 PostgreSQL Drills run this exact workflow. Only the target and the purpose field differ. v 1.0 · owner Backup Platform · date 2026-09

Decisions

  • Authorisation checks both the requester and the target: the requester's team owns the datastore, and the target environment's classification is at least as strict as the source. A restore into the wrong place fails at key unwrap, not on someone reading a policy.
  • The lock extension (step 6) comes before any read. Without it, a copy on its last retained day can expire halfway through the restore that needed it.
  • The restore identity can unwrap keys only for classifications its target is cleared for. The key service is where environment separation is enforced in cryptography, not in configuration.

Numbers

  • Request to first bytes moving: p95 of 10 minutes, including authorisation.
  • The completion estimate is recalculated every 30 s from observed throughput and remaining replay. If it passes the tier RTO, the restore is escalated while it is still running.

Omitted

  • Partial restore (one table) follows the same path into a scratch instance, then pg_dump of the named objects. The extra hop is kept so partial restores exercise the full restore too.