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_unit rows (~hundreds of bytes each),
  • 6 new job_queue rows,
  • 1 new queue_heartbeat row,
  • 1 new iu_staging_record row + 3 new iu_staging_payload rows (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).

Back to Knowledge Hub knowledge/dev/laws/dieu44-trien-khai/v0.6-dieu45-phase-3-mark-cut-queue-pilot-dieu37-write-channel/02-baseline-and-backup.md