KB-3171
Phase 3 — Baseline snapshot + pg_dump backup
4 min read Revision 1
dieu45phase3baselinepg-dumpbackup2026-05-26
Phase 3 — Baseline snapshot + pg_dump backup
Captured before any pilot mutation.
1. Row counts
| Surface | Baseline | Post-pilot | Δ |
|---|---|---|---|
job_queue |
0 | 6 | +6 (all succeeded, this pilot) |
job_dead_letter |
0 | 0 | 0 |
queue_heartbeat |
1 | 2 | +1 (dieu45_phase3_pilot) |
iu_core.iu_staging_record |
4 | 5 | +1 (258c715c…, this pilot) |
iu_core.iu_staging_payload |
7 | 10 | +3 (cut_manifest, mark_report, coverage_proof) |
information_unit |
175 | 192 | +17 (DIEU-37 IUs) |
iu_vector_sync_point |
152 | 152 | 0 |
event_outbox |
134,803 | 134,803 | 0 |
iu_piece_membership |
223 | 223 | 0 (cut uses parent_or_container_ref linkage, not collection membership) |
dot_config queue.* keys |
12 | 12 | 0 (toggled queue.job_substrate.enabled true→false; net unchanged) |
2. Baseline dot_config queue gates
queue.dlq.replay_enabled | false
queue.heartbeat.enabled | true
queue.heartbeat.stale_threshold_seconds | 300
queue.job_substrate.enabled | false
queue.lease.duration_sec | 300
queue.lease.reaper_dry_run_only | true
queue.lease.reaper_enabled | false
queue.notify.enabled | false
queue.retry.backoff_base_sec | 10
queue.retry.max_attempts_default | 5
queue.runtime.phase | phase2_governance
queue.worker.enabled | false
iu_core.composer_enabled | false
Exit state is identical (substrate + composer flipped back, runtime.phase unchanged).
3. Existing dieu37 staging context (pre-pilot)
c3f3f073-24a4-4ed2-b9e9-88f45a11b322 | dieu37-proof-mark-manifest | consumed | (from 110500x)
06a2fc30-9eae-4b1e-a9f6-6cb41e080b68 | knowledge/dev/laws/dieu37-governance-organization-law.md | pending_review | op-mark-dieu37-full-v3.3-20260526-mark-only (Codex earlier attempt)
Pilot used a fresh idempotency_key (dieu45-phase3-pilot-dieu37-20260526-write-channel) →
new staging_record_id=258c715c… so the existing pending_review row (06a2fc30) remained
untouched and unaffected. It is now flagged as a carry-forward item — operator must either
complete or reject it (see 09-carry-forward.md).
4. pg_dump backups
| Stage | Path | Size |
|---|---|---|
| Baseline | /tmp/dieu45_phase3/baseline_20260526T142119Z.fc |
83,207,353 B |
| Post-pilot | /tmp/dieu45_phase3/post_pilot_20260526T152141Z.fc |
83,224,464 B |
| Δ | — | +17,111 B |
Both dumps were taken inside the postgres container, custom format (-Fc), full data.
The delta (~17 kB) is consistent with:
- 17 new
information_unitrows (~hundreds of bytes each), - 6 new
job_queuerows, - 1 new
queue_heartbeatrow, - 1 new
iu_staging_recordrow + 3 newiu_staging_payloadrows (containing the manifest JSON ~28 kB compressed into the dump).
5. Alias signatures recorded for D30 immutability check
fn_iu_op_mark_file(p_source_text text, p_source_ref text, p_pieces jsonb, p_actor text,
p_source_kind text, p_idempotency_key text, p_mark_report_md text, p_workflow_ref text)
fn_iu_op_verify_mark(p_staging_record_id uuid, p_approve boolean,
p_approval_doc_id text, p_approver text, p_actor text)
fn_iu_op_cut(p_staging_record_id uuid, p_apply boolean, p_actor text, p_open_composer boolean)
fn_iu_op_verify_cut(p_run_id uuid, p_actor text)
fn_iu_op_cleanup_dry_run(p_older_than_days integer, p_actor text)
These were re-verified at exit (see 06-d30-regression-results.md T5 — identical).