a month ago
My Postgres database password is out of sync. Even running railway run python
with the injected PGPASSWORD environment variable fails with "password authentication
failed for user postgres". The database service uses postgres-ssl:18.
I cannot connect with any credential, so I can't run ALTER USER to fix it myself.
Please reset or resync the Postgres password WITHOUT deleting data — the production
database has real data.
Environment: production
Service: Postgres
1 Replies
a month ago
Your Postgres service has a Credentials tab in the dashboard's Database view that lets you regenerate the password and keep the environment variables in sync, no SQL access required. After regenerating, manually redeploy any service that depends on the updated password variable.
Status changed to Awaiting User Response Railway • about 1 month ago
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 1 month ago