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

b7ccab20f362044e12a146b5ca4ad73c749b4674 · 2026-09-15 04:07:21 -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 b7ccab20f362044e12a146b5ca4ad73c749b4674
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Tue Sep 15 04:07:21 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 cdf81fe..33f6eaf 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;
 }

← cc826bb governance(TK-11370): make live-by-default Shopify writers d · back to Greenland Onboard · (newest)