I'm locked out of my production Postgres database after a failed password rotation. The postgres role password is desynced — neither Railway's stored credentials nor the password I set during the rotation will authenticate. railway connect and direct psql both fail with password authentication failed for user "postgres".

The database service is online and the data is intact — I just need the postgres role password reset so I can regain access. I'm on the Hobby plan with no backups, so I can't restore, and I want to avoid recreating the service since that would lose my data.

Project: superb-adventure (full IDs available on request). Service: Postgres, production environment.

Could you reset the postgres user password, or advise the safe way to do it for this Postgres image? Happy to share account details privately. Thanks.