7 days ago
Project ID: 18e033d4-a8e7-401e-9304-e861f2aecb05
Service: Postgres-PNM
Symptom: DATABASE_PUBLIC_URL password authentication fails consistently from external connections despite multiple credential rotations. Internal app connections via DATABASE_URL work fine. External proxy (zephyr.proxy.rlwy.net:55803) appears to hold a stale password that doesn't update when credentials are rotated.
2 Replies
7 days ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • 7 days ago
7 days ago
connect internally 1st copy the values SELECT rolname, rolpassword FROM pg_authid WHERE rolname = 'postgres'; and then change again your cred, see if change is happening , if not do it manually by ALter query
ALTER ROLE postgres WITH PASSWORD 'your-new-password-from-PGPASSWORD'; if this works , you need Reset the TCP Proxy endpoint for rotational change