Runbook Map: Umami Postgres Major Upgrade

Runbook Map: Umami Postgres Major Upgrade A workflow diagram generated by Archify. 01 / Prepare 02 / Cutover EX / STOP gates 04 / After the point of no return 05 / Recover Pre-flight · read-only checks · Prepare Pre-flight read-only checks Backup · encrypted dump, listed · Prepare Backup encrypted dump, listed Staging validation · restore on a workstation · Prepare Staging validation restore on a workstation Quiesce · timer off, freeze, final dump · Cutover Quiesce timer off, freeze, final dump Switch to PG18 · stop PG15, new volume · Cutover Switch to PG18 stop PG15, new volume Restore, start umami · internal only · Cutover Restore, start umami internal only Start Caddy · point of no return · Cutover · IRREVERSIBLE Start Caddy point of no return IRREVERSIBLE Verify cutover dump · decrypt, pg_restore --list · STOP gates · STOP Verify cutover dump decrypt, pg_restore --list STOP Layout gates · mount, fresh cluster, SCRAM · STOP gates · STOP Layout gates mount, fresh cluster, SCRAM STOP Manifest and migrations · counts, checksums, no-op · STOP gates · STOP Manifest and migrations counts, checksums, no-op STOP Verify and finalize · heartbeat, supervised retention · After the point of no return Verify and finalize heartbeat, supervised retention Pre-Caddy revert · PG15 volume untouched · Recover Pre-Caddy revert PG15 volume untouched Roll forward or back · lossy rollback needs a record · Recover · DECISION Roll forward or back lossy rollback needs a record DECISION problem heartbeat lossy rollback fail dump verified fail layout ok all pass fail final dump restored pin PR approved PG18 healthy Legend Step STOP gate or decision Irreversible step Data safeguard