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
Back to Knowledge Hub knowledge/dev/reports/architecture/one-roof-production-release-engineering-ultra-macro-2026-06-03/sql-prod-99_run_all.md