Pooler authentication broken after migration — no password works
Solvedconst { Pool } = require('pg');
const p = new Pool({ connectionString: 'postgresql://postgres.rrcaxbdvxuuturgpguji:PASSWORD@aws-0-us-west-2.pooler.supabase.com:5432/postgres' });
p.query('SELECT 1').then(r => { console.log('OK', r.rows); p.end(); }).catch(e => { console.error('FAIL:', e.message); p.end(); });
Error: password authentication failed for user "postgres"
Tested from 2 different machines/networks (VPS + MacBook) — same result
SQL Editor works fine (service role)
Network restrictions: none
Connection string matches dashboard exactly
Reset password 3 times — none propagate
Any help appreciated.
const p = new Pool({ connectionString: 'postgresql://postgres.rrcaxbdvxuuturgpguji:PASSWORD@aws-0-us-west-2.pooler.supabase.com:5432/postgres' });
p.query('SELECT 1').then(r => { console.log('OK', r.rows); p.end(); }).catch(e => { console.error('FAIL:', e.message); p.end(); });
Error: password authentication failed for user "postgres"
Tested from 2 different machines/networks (VPS + MacBook) — same result
SQL Editor works fine (service role)
Network restrictions: none
Connection string matches dashboard exactly
Reset password 3 times — none propagate
Any help appreciated.
