2 months ago
The database stopped accepting connections, so I removed the deployment and redeployed it, but now it won't deploy and shows “no information.”
The database appears to be empty, but I have over 1 GB of data, and the configured backups also seem empty. What should I do in this case? Please explain everything to me so I can deploy my database and continue providing this service, which is for doctors and is extremely necessary.
7 Replies
2 months ago
Your "DB IMPORTANT" service currently has a new, empty volume (0 MB used), but we can see an unattached volume in the same project that holds approximately 1.1 GB of data, which is likely your original database data. When you removed and recreated the database service, the original volume was detached. You should be able to recover by locating the unattached volume on the project canvas and reconnecting it to your service, making sure the mount path is set to /var/lib/postgresql/data.
Status changed to Awaiting User Response Railway • 2 months ago
Railway
Your "DB IMPORTANT" service currently has a new, empty volume (0 MB used), but we can see an unattached volume in the same project that holds approximately 1.1 GB of data, which is likely your original database data. When you removed and recreated the database service, the original volume was detached. You should be able to recover by locating the unattached volume on the project canvas and reconnecting it to your service, making sure the mount path is set to `/var/lib/postgresql/data`.
2 months ago
But now when I drag that volume, it shows up as empty again—0 bytes—and it won't let me unmount it. How can I do that?
Status changed to Awaiting Railway Response Railway • 2 months ago
2 months 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 • 2 months ago
2 months ago
Seems to be the same issue as here: https://station.railway.com/questions/postgres-redeploy-appears-stuck-pg-boun-8530ee6c
2 months ago
I have the same problem. I don't know what happened, and I need help figuring out why my backups were lost, what happened to my volume, and why it changed. I need to fix this as soon as possible—doctors and patients depend on it.
2 months ago
I have the same problem. Postgres on Railway has stopped accepting any new connections since about 22 minutes ago. Restarting the service is also not working. Seems to be isolated to one environment (production) in my case.
2 months ago
I need help
2 months ago
Looks like "Redeploy"-ing (not just "Restart"-ing) both pgbouncer and postgres fixed the connections problems for me. Critical thing was redeploying pgbouncer.
Status changed to Awaiting User Response Railway • 2 months ago
2 months ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • about 2 months ago