4 days ago
Hello Railway Support,
I’m using Railway Postgres in production and I’d like to safely rotate the database credentials.
I already have PITR enabled, a recent Railway backup, and an external pg_dump backup stored safely.
When I tried using the “Regenerate Password” option under Postgres → Database → Config, I got this error:
“Failed to regenerate password — Password reset is not supported for Postgres HA clusters.”
I also noticed that manually editing POSTGRES_PASSWORD shows a warning saying it may only change the environment variable, not the actual database password, so I don’t want to do that and risk breaking the application.
Could you please let me know the safest supported way to rotate the PostgreSQL credentials for this service?
This is a production database, so my main concern is avoiding data loss and making sure the connected web service can reconnect properly after the change.
Thank you.
3 Replies
4 days ago
This thread has been opened as a public bounty so the community can help solve it. The thread and any further activity are now visible to everyone.
Status changed to Open Railway • 4 days ago
4 days ago
Click on the big Postgres HA group, go to the Database, tab, and you'll be able to regenerate the credentials from the Config tab.
4 days ago
I followed the suggested path exactly:
Postgres service → Database → Config → Regenerate Password
But the same error still appears:
“Failed to regenerate password — Password reset is not supported for Postgres HA clusters.”
The application is still healthy, but I need a supported way to rotate the Postgres credentials for this HA cluster without data loss and without breaking the connected web service.
Can you confirm the correct procedure for rotating credentials on a Railway Postgres HA cluster?
Status changed to Awaiting Railway Response Railway • 3 days ago