TK-11438: migrate postgres pool to unix socket (darwin fallback)

ef312d0f65a8beed69c02e7ca728cf0ce5b663b8 · 2026-09-15 04:07:19 -0700 · steve@designerwallcoverings.com

Use process.env.PGHOST || darwin?/tmp:127.0.0.1 so Mac2 services use the
unix socket at /tmp and Kamatera keeps TCP until its own migration.
Undo: git revert HEAD

Files touched

M lib/vendor-requests.js

Diff

commit ef312d0f65a8beed69c02e7ca728cf0ce5b663b8
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Tue Sep 15 04:07:19 2026 -0700

    TK-11438: migrate postgres pool to unix socket (darwin fallback)
    
    Use process.env.PGHOST || darwin?/tmp:127.0.0.1 so Mac2 services use the
    unix socket at /tmp and Kamatera keeps TCP until its own migration.
    Undo: git revert HEAD
---
 lib/vendor-requests.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/vendor-requests.js b/lib/vendor-requests.js
index 52ed92b..8d8db3f 100644
--- a/lib/vendor-requests.js
+++ b/lib/vendor-requests.js
@@ -49,7 +49,7 @@ const GEORGE_AUTH = firstEnv('GEORGE_BASIC_AUTH', GEORGE_ENVS) || 'admin:';
 
 let pool = null;
 function db() {
-  if (!pool) pool = new Pool({ host: '127.0.0.1', port: 5432, user: 'dw_admin', database: 'dw_unified', password: PGPASS, max: 3 });
+  if (!pool) pool = new Pool({ host: process.env.PGHOST || (process.platform === 'darwin' ? '/tmp' : '127.0.0.1'), port: 5432, user: 'dw_admin', database: 'dw_unified', password: PGPASS, max: 3 });
   return pool;
 }

← 9904c55 deploy: guard prod-only runtime data from rsync --delete · back to Astek Landing · TK-11438: migrate build script postgres connections to unix d25e009 →