Hi team I attempted a password rotation tonight via ALTER USER followed by env var updates. After a Postgres service restart, I'm now locked out of the database with FATAL: password authentication failed for user "postgres" on every connection (including railway connect Postgres).

The DB has data my production app depends on — please do NOT reset/recreate the service. I need either (a) a password reset on the postgres user without data loss, or (b) guidance on the safest recovery path. T

Thanks