[object Object]

← back to Bertha

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

ce85d9935b0ecbbaa86657644f1415954647d089 · 2026-09-17 16:59:44 -0700 · Steve Abrams

Files touched

Diff

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

    TK-11438: migrate pg fallbacks to unix socket (?host=/tmp) — local+reversible
---
 kalshi-dash/server.js | 4 ++--
 react-dash/server.js  | 2 +-
 src/lib/db.js         | 2 +-
 3 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/kalshi-dash/server.js b/kalshi-dash/server.js
index 25b2cbf..378ba78 100644
--- a/kalshi-dash/server.js
+++ b/kalshi-dash/server.js
@@ -360,7 +360,7 @@ async function refreshKalshiEnv() {
 
 // ── Database ──
 const pool = new pg.Pool({
-  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/bertha_betting'),
+  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@localhost/bertha_betting?host=/tmp'),
   max: 10,
   idleTimeoutMillis: 30000,
 });
@@ -4889,7 +4889,7 @@ const server = http.createServer(async (req, res) => {
 // Stores everything in PostgreSQL, tracks own performance
 // ══════════════════════════════════════════════════════════════
 
-const KEN_DB = (process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/dw_unified');
+const KEN_DB = (process.env.DATABASE_URL || 'postgresql://dw_admin@localhost/dw_unified?host=/tmp');
 const kenPool = new pg.Pool({ connectionString: KEN_DB, max: 20, idleTimeoutMillis: 30000 });
 async function kenQ(text, params) { return kenPool.query(text, params); }
 
diff --git a/react-dash/server.js b/react-dash/server.js
index 2a2bd67..cadbad2 100644
--- a/react-dash/server.js
+++ b/react-dash/server.js
@@ -30,7 +30,7 @@ const ALLOWED_EMAILS = (process.env.ALLOWED_EMAILS || '').split(',').filter(Bool
 const googleClient = GOOGLE_CLIENT_ID ? new OAuth2Client(GOOGLE_CLIENT_ID) : null;
 
 const pool = new pg.Pool({
-  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/bertha_betting'),
+  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@localhost/bertha_betting?host=/tmp'),
   max: 10,
   idleTimeoutMillis: 30000,
 });
diff --git a/src/lib/db.js b/src/lib/db.js
index c2e0c46..dd9d1a2 100644
--- a/src/lib/db.js
+++ b/src/lib/db.js
@@ -1,7 +1,7 @@
 const { Pool } = require('pg');
 
 const pool = new Pool({
-  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@127.0.0.1:5432/bertha_betting'),
+  connectionString: (process.env.DATABASE_URL || 'postgresql://dw_admin@localhost/bertha_betting?host=/tmp'),
   max: 10,
   idleTimeoutMillis: 30000,
   connectionTimeoutMillis: 5000,

← c13ebe7 security: npm audit fix --omit=dev (non-breaking) — resolves  ·  back to Bertha  ·  (newest)