VCC: fix DB fallback connection string (dw_admin@127.0.0.1, not socket→root)

9ca4e85afb1130ef002eff6a8d6d0bd62e39a8a9 · 2026-06-24 07:30:28 -0700 · Steve

Victor's pool fallback was postgresql:///dw_unified?host=/tmp which connects as OS
user root ('role root does not exist') when DATABASE_URL is unset (it is — /root/.env
has none). Match the working fleet form (priya-agent) so syncVendorCounts can run.

Files touched

M DW-Agents/vendor-command-center/server.js

Diff

commit 9ca4e85afb1130ef002eff6a8d6d0bd62e39a8a9
Author: Steve <steve@designerwallcoverings.com>
Date:   Wed Jun 24 07:30:28 2026 -0700

    VCC: fix DB fallback connection string (dw_admin@127.0.0.1, not socket→root)
    
    Victor's pool fallback was postgresql:///dw_unified?host=/tmp which connects as OS
    user root ('role root does not exist') when DATABASE_URL is unset (it is — /root/.env
    has none). Match the working fleet form (priya-agent) so syncVendorCounts can run.
---
 DW-Agents/vendor-command-center/server.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/DW-Agents/vendor-command-center/server.js b/DW-Agents/vendor-command-center/server.js
index f230a02a..eef3a09c 100644
--- a/DW-Agents/vendor-command-center/server.js
+++ b/DW-Agents/vendor-command-center/server.js
@@ -32,7 +32,7 @@ const PORT = 9660;
 
 // --- Database ---
 const pool = new Pool({
-  connectionString: process.env.DATABASE_URL || 'postgresql:///dw_unified?host=/tmp',
+  connectionString: process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/dw_unified',
   max: 10,
   idleTimeoutMillis: 30000,
 });

← fa89fca7 auto-save: 2026-06-24T07:25:27 (2 files) — vendor-scrapers/c · back to Designer Wallcoverings · pending-approval: draft live Coastal Mist oil-filter image f 3b51069d →