2 months ago
▎ I changed the region of my PostgreSQL service and the old volume with all production data is now orphaned.
▎
▎ Project: pharamila
▎ Project ID: 94c4322f-081b-4694-ae61-908278fa1877
▎ Environment: production
▎ Postgres service ID: 81cc0453-704d-4219-ae95-7448005e50f8
▎ Public domain: postgres-production-9ada1.up.railway.app
▎
▎ The database is now empty (Flyway recreated the schema but all data is gone). The old volume with products, users,
▎ and orders must still exist in the previous region. Please restore it urgently — this is a live production
▎ e-commerce store.
NOT patient-unity, on project pharamila
12 Replies
2 months ago
Your Postgres service currently has no volume attached in the production environment, and the previous volume is no longer present in the project. Changing a service's region is a user-initiated action, and we are not able to restore data lost as a result. We're sorry we can't do more here.
Status changed to Awaiting User Response Railway • about 2 months ago
Railway
Your Postgres service currently has no volume attached in the production environment, and the previous volume is no longer present in the project. Changing a service's region is a user-initiated action, and we are not able to restore data lost as a result. We're sorry we can't do more here.
2 months ago
we have a paid plan where isa our backups?
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
Volume backups are stored on the volume they belong to, so when the volume was lost during the region change, any backups on it were lost with it. There is no separate copy we can restore from in this case.
Status changed to Awaiting User Response Railway • about 2 months ago
2 months ago
please connefct me to a real person\
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
please connect me to a real support person
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
We understand this is a difficult situation for a production store. The previous replies are accurate: the volume that held your Postgres data was lost during the region change, and we are not able to recover data lost as a result of that action. We are sorry we cannot do more.
Status changed to Awaiting User Response Railway • about 2 months ago
2 months ago
that makes no sense when there is no warning showed while changing the region, no warnings about that backups are gonna be gone with just changing the region of database.
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
We have noted the feedback about the region-change flow not warning about the impact on volumes. The data from the previous volume is not recoverable.
Status changed to Awaiting User Response Railway • about 2 months ago
2 months ago
please check if it's possible to get a backup from previous region postgres, ask a technical person this is production database
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
There was never a volume, so there were never any backups. For data persistence, use a volume at the correct mount point going forward.
Status changed to Awaiting User Response Railway • about 2 months ago
2 months ago
so simple is that? hole prod database is gone and railway does not have anything? with a paid plan. and all you can do is saying sorry while your dashboard shows 0 warning during just changing a region of databse
Status changed to Awaiting Railway Response Railway • about 2 months ago
2 months ago
Since you explicitly set up the database without a volume, we couldn't have warned you. Apologies, we cannot do more here.
Status changed to Awaiting User Response Railway • about 2 months ago
Status changed to Solved brody • about 2 months ago

