TK-11438: migrate build script postgres connections to unix socket

5ad41d6739636a704348cdf32d4e316a5a6c868b · 2026-09-15 04:08:03 -0700 · steve@designerwallcoverings.com

Files touched

M scripts/build-rwltd-data.js

Diff

commit 5ad41d6739636a704348cdf32d4e316a5a6c868b
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Tue Sep 15 04:08:03 2026 -0700

    TK-11438: migrate build script postgres connections to unix socket
---
 scripts/build-rwltd-data.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/scripts/build-rwltd-data.js b/scripts/build-rwltd-data.js
index 377ec3e..d332e5e 100644
--- a/scripts/build-rwltd-data.js
+++ b/scripts/build-rwltd-data.js
@@ -195,7 +195,7 @@ async function fetchVendorMeta(vendorCode, fmName) {
   const PW = (() => {
     try { const m = fs.readFileSync(require('os').homedir() + '/Projects/secrets-manager/.env', 'utf8').match(/^DW_ADMIN_DB_PASSWORD=(.*)$/m); return m ? m[1].replace(/^["']|["']$/g, '').trim() : ''; } catch { return ''; }
   })();
-  const pool = new Pool({ host: '127.0.0.1', port: 5432, user: 'dw_admin', database: 'dw_unified', password: PW, max: 1 });
+  const pool = new Pool({ host: process.env.PGHOST || (process.platform === 'darwin' ? '/tmp' : '127.0.0.1'), port: 5432, user: 'dw_admin', database: 'dw_unified', password: PW, max: 1 });
   const vr = (await pool.query(`SELECT vendor_name, vendor_discount_pct, pricing_unit, pricing_model, pricing_notes, sample_price FROM vendor_registry WHERE vendor_code=$1`, [vendorCode])).rows[0] || {};
   const fm = (await pool.query(`SELECT phone, email_1, account_num FROM fmpro WHERE vendor_name ILIKE $1 AND (phone IS NOT NULL OR email_1 IS NOT NULL) LIMIT 1`, [fmName])).rows[0] || {};
   await pool.end();

← 2404f94 TK-11438: migrate postgres pool to unix socket (darwin fallb · back to Reidwitlin Landing · (newest)