york-cadence: remove dead PG const (unused; q() is the only live psql path) [Cody gate]

b2c0e8f831f88895afe10011a03d677ff811816e · 2026-08-25 12:05:26 -0700 · Steve Abrams

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

M cadence/york-cadence.mjs

Diff

commit b2c0e8f831f88895afe10011a03d677ff811816e
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Aug 25 12:05:26 2026 -0700

    york-cadence: remove dead PG const (unused; q() is the only live psql path) [Cody gate]
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 cadence/york-cadence.mjs | 1 -
 1 file changed, 1 deletion(-)

diff --git a/cadence/york-cadence.mjs b/cadence/york-cadence.mjs
index a27b787..b2dd931 100644
--- a/cadence/york-cadence.mjs
+++ b/cadence/york-cadence.mjs
@@ -20,7 +20,6 @@ const URL=`https://${SHOP}/admin/api/${VER}/graphql.json`;
 // 127.0.0.1:5432. TCP 5432's listener flaps transiently (it went down Aug 15 → uncaught execSync
 // throw → cadence crash); the /tmp socket is always present. Keep -U dw_admin (md5/scram over the
 // socket authenticates cleanly on this box's pg_hba — least behavior change).
-const PG='PGPASSWORD=DW2024! /opt/homebrew/opt/postgresql@14/bin/psql -h /tmp -U dw_admin -d dw_unified -tA -F\'\x1f\' -c';
 // multi-line SQL breaks `psql -c "<sql>"` ("invalid command \n") — the onboardCand query is
 // multi-line and was silently throwing into a catch{}, falsely returning onboardReady=0 for
 // MONTHS. Route every query through a temp .sql file + `-f` so multi-line SQL is safe.

← 9120fee york-cadence: connect PG over /tmp socket instead of TCP 127 · back to York Reprice 2026 08 · auto-data-snapshot: 2026-08-25T12:06:42 (1 data files) — cad 6cdd76b →