a month ago
Hi, my PostgreSQL database has been stuck in recovery mode for over 24 hours, blocking all deployments (17 consecutive failures).
Project: intelligent-spirit (27b28289-aea8-450b-8267-f94e3934738b)
Environment: production
PostgreSQL service: switchyard.proxy.rlwy.net:47120
Last successful deploy: 2026-06-06 at 21:09
Deployment ID: 7dcf4e16-25c9-4d28-8760-50e12744e06e
Error: FATAL: the database system is in recovery mode
Please investigate and restore the database to operational state. This requires infrastructure-level intervention (restart or failover).
Thank you.
4 Replies
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • 30 days ago
a month ago
try redeploy source image
open your database service > open command palette (Ctrl+K) > select "Redeploy source image"
mayori
try redeploy source image open your database service > open command palette (Ctrl+K) > select "Redeploy source image"
a month ago
unfortunately it didn't work.
Deployment failed during the deployment process
The build completes successfully each time, but the migration cannot connect and times out after 120 seconds.
mayori
the build succes but the deployment is not?
a month ago
Yes — build succeeds every time, but the pre-deploy command (python migrate.py) fails because the database still returns FATAL: the database system is in recovery mode.
I have already removed the pre-deploy command as a workaround, and the worker is now running. However, the database itself is still in recovery mode — all DB writes/reads fail. The worker cannot persist any data.
Is there any way to force a PostgreSQL restart or failover at the infrastructure level? The database has been in this state for over 25 hours.