← back to Tk11438 Postgres Migration

README.md

35 lines

# TK-11438 PostgreSQL socket migration

Status: PARTIAL. Three approved batches applied; full fleet remains incomplete.

First batch: showroom and Pattern Design Lab source, runtime and durable configs
migrated and independently reverified (15 checks; 3,201 products/1,694 designs).

Ken batch: source commit d840eb6; both databases now use Unix sockets. Effective
and saved PM2 URLs match the shell-sourced .env. Hourly wrapper URI is migrated;
its underlying SELECT-only module was tested without invoking its email branch.
The reconciliation launchd job is loaded with the socket URL and exited0.
Independent26/26 checks plus parent stability observation passed.

Read verification/ken-rollout/parent-acceptance.json for acceptance and limits.
Private rollback materials are in verification/ken-rollout/private, mode0700,
files0600, excluded from git. Never stage them. Helper rollback is guarded and
must only be invoked to address an actual regression; no live rollback was needed.

Captured trading switches and Ken config hashes match. Whole risk_state hash
changed consistently with automatic weather-cache updates; uncaptured keys cannot
be proven unchanged retrospectively. No email sends were invoked by this work.

Original217 files plus an invalid directory entry and expanded candidates still
need full disposition/migration. Gracie, other services and TCP shutdown remain
outside the Ken approval. NEXT-BATCH.md retains its historical approved scope.

Remaining inventory is now classified, with explicit unresolved/runtime gaps.
See verification/fleet-classification/README.md and GRACIE-BATCH.md for the
prepared next batch. No additional rollout has been applied.

Gracie batch APPLIED/VERIFIED locally, source9661303: PostgreSQL sockets and
127.0.0.1-only HTTP,150catalogitems preserved,auth+private-interface checks pass.
Independent evidence and private rollback: verification/gracie-rollout/.
No online publishing or emails. Overall fleet ticket remains incomplete.