TK-11438: migrate pg fallback to unix socket (?host=/tmp) — local+reversible

2dfaf8b5fbefc9be529c1ba0c5d58bb6d794468a · 2026-09-17 16:59:46 -0700 · Steve Abrams

Files touched

M server.js

Diff

commit 2dfaf8b5fbefc9be529c1ba0c5d58bb6d794468a
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Sep 17 16:59:46 2026 -0700

    TK-11438: migrate pg fallback to unix socket (?host=/tmp) — local+reversible
---
 server.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/server.js b/server.js
index b810f7b..2062ec8 100644
--- a/server.js
+++ b/server.js
@@ -123,7 +123,7 @@ function setSetting(key, value) { db.prepare('INSERT OR REPLACE INTO settings (k
 let districtLookup = {};
 try {
   const { Pool } = require('pg');
-  const pool = new Pool({ connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/sdcc'), max: 2 });
+  const pool = new Pool({ connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@localhost/sdcc?host=/tmp'), max: 2 });
   pool.query('SELECT zip_codes, district_code, representative_name, representative_party FROM congressional_districts WHERE representative_name IS NOT NULL LIMIT 500')
     .then(result => {
       for (const row of result.rows) {

← 57570ab creds-safe fetch guard: resolve relative fetch vs credential · back to SDCC Stories · (newest)