KB-6D95
One-Roof Prod Release Ultra-Macro — Executor sql/prod/99_run_all.sql (2026-06-03)
2 min read Revision 1
one-roof-governanceproduction-releaseexecutorsql2026-06-03
Self-guarding production executor (sha256 4dc8d2ac…). Canonical source on disk: sql/prod/99_run_all.sql. Runs tiers in order with ON_ERROR_STOP; aborts at Tier 0 unless db=directus AND os_proposal_approvals>=1. NOT executed on production.
\set ON_ERROR_STOP on
\pset pager off
\timing on
\i 00_preflight.sql -- TIER 0 — PREFLIGHT / GATE
\i 10_structure.sql -- TIER 1 — STRUCTURE (inert): 11 tables + 31 views + 1 fn
\i 20_responsibility_axis.sql -- TIER 2 — responsibility axis (effect-inert; gap stays 210)
\i 30_ownership_seed.sql -- TIER 3 — ownership seed (sovereign; gap 210->0; needs -v ratified_apr=...)
\i 40_containment.sql -- TIER 4 — containment axis (gap 0)
\i 50_topic_finalization.sql -- TIER 5 — topic finalization (divergent 0, projection_gap 0)
\i 60_scanner_baseline.sql -- TIER 6 — scanner baseline (fail-closed: critical 0, emittable 0)
\i 90_verify.sql -- TIER 8 — post-rollout verification
Invocation (only after ratification sets ospa>=1):
ssh contabo -> docker exec -i postgres psql -U workflow_admin -d directus \
-v ON_ERROR_STOP=1 -v ratified_apr=<REAL_RATIFIED_APR_CODE> \
-f 99_run_all.sql 2>&1 | tee rollout_$(date +%Y%m%dT%H%M%SZ).log