← back to Tk11438 Postgres Migration

Record observed Ken TCP session and make evidence self contained

ca5b0b3a153a603ad4222e3aafc1d351e02b1b2b · 2026-09-11 08:18:09 -0700 · Steve Abrams

Files touched

• M APPROVAL.md
• M inventory.py
• M verification/inventory.json
• M verification/postgres-baseline.json

Diff

commit ca5b0b3a153a603ad4222e3aafc1d351e02b1b2b
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri Sep 11 08:18:09 2026 -0700

    Record observed Ken TCP session and make evidence self contained
---
 APPROVAL.md                         |  2 ++
 inventory.py                        |  4 ++--
 verification/inventory.json         |  2 +-
 verification/postgres-baseline.json | 31 +++++++++++++++++++++++++++++--
 4 files changed, 34 insertions(+), 5 deletions(-)

diff --git a/APPROVAL.md b/APPROVAL.md
index 554b6a0..d42deb8 100644
--- a/APPROVAL.md
+++ b/APPROVAL.md
@@ -30,6 +30,8 @@ the durable launcher configuration before changing transient PM2 environment.
   Of the union, 634 files contain an explicit local PostgreSQL URL. None of these
   counts establishes the number of deployed consumers.
 - PostgreSQL 14.23 advertises socket directory `/tmp`, TCP `localhost`, port 5432.
+- The later saved baseline contains an active TCP session to database `ken`
+  from `::1`. This directly disproves readiness to close TCP now.
 - Installed pg drivers for showroom, patterndesignlab, and Norma-platform passed
   six checks: socket SELECT with read-only enforced, plus missing socket ENOENT
   with no TCP fallback, for each driver. All test connections closed.
diff --git a/inventory.py b/inventory.py
index 669fd6c..2a37a96 100644
--- a/inventory.py
+++ b/inventory.py
@@ -30,8 +30,8 @@ def category(p):
     return 'other-review'
 
 def main():
-    original = {(ROOT / x.removeprefix('./')).absolute() for x in Path('/tmp/tcp-all.txt').read_text().splitlines() if x}
-    current = {Path(x) for x in Path('/tmp/tk11438-candidates.txt').read_text().splitlines() if x}
+    original = {(ROOT / x.removeprefix('./')).absolute() for x in (OUT/'original-218-paths.txt').read_text().splitlines() if x}
+    current = {Path(x) for x in (OUT/'current-candidate-paths.txt').read_text().splitlines() if x}
     rows = []
     for p in sorted(original | current):
         row = {'path': str(p), 'project': p.relative_to(ROOT).parts[0] if p != ROOT else '(invalid-directory-entry)', 'original_218': p in original, 'current_scan': p in current, 'category': category(p)}
diff --git a/verification/inventory.json b/verification/inventory.json
index dd83c67..4b4986d 100644
--- a/verification/inventory.json
+++ b/verification/inventory.json
@@ -1,6 +1,6 @@
 {
   "summary": {
-    "timestamp": "2026-09-11T13:50:01.686774+00:00",
+    "timestamp": "2026-09-11T15:18:09.283103+00:00",
     "original": 218,
     "current_candidates": 841,
     "union": 851,
diff --git a/verification/postgres-baseline.json b/verification/postgres-baseline.json
index 2eb4640..ad51760 100644
--- a/verification/postgres-baseline.json
+++ b/verification/postgres-baseline.json
@@ -1,2 +1,29 @@
-{"timestamp" : "2026-09-11T08:13:55.983034-07:00", "settings" : {"socket_dirs" : "/tmp", "listen_addresses" : "localhost", "port" : "5432", "socket_connection" : true}, "clients" : [{"datname":"ken","usename":"macstudio3","application_name":"","client_addr":"::1","client_port":61576,"pid":55498,"state":"idle"}, 
- {"datname":"dw_unified","usename":"macstudio3","application_name":"","client_addr":null,"client_port":-1,"pid":54558,"state":"active"}]}
+{
+  "timestamp": "2026-09-11T08:13:55.983034-07:00",
+  "settings": {
+    "socket_dirs": "/tmp",
+    "listen_addresses": "localhost",
+    "port": "5432",
+    "socket_connection": true
+  },
+  "clients": [
+    {
+      "datname": "ken",
+      "usename": "macstudio3",
+      "application_name": "",
+      "client_addr": "::1",
+      "client_port": 61576,
+      "pid": 55498,
+      "state": "idle"
+    },
+    {
+      "datname": "dw_unified",
+      "usename": "macstudio3",
+      "application_name": "",
+      "client_addr": null,
+      "client_port": -1,
+      "pid": 54558,
+      "state": "active"
+    }
+  ]
+}

← 8effefa Stage PostgreSQL socket migration evidence and first batch a  ·  back to Tk11438 Postgres Migration  ·  Record first batch socket migration E2E verification a93a4b2 →