14 days ago
Production PostgreSQL database was deleted by mistake.
No user backup exists.
Project: SOConvergence
Affected services: App and/or Platform
Need emergency restore or undelete.
Please check soft-delete, volume recovery, platform disaster recovery, or point-in-time recovery options.
Deletion happened around: [exact time]
5 Replies
14 days ago
Our databases are unmanaged, so automatic snapshots, WAL recovery, and PITR aren't available unless you set up volume backups or PITR yourself. We don't recover data lost to user-initiated actions. Going forward, enable volume backups on your stateful services so you can self-restore if this happens again.
Status changed to Awaiting User Response Railway • 14 days ago
Railway
Our databases are unmanaged, so automatic snapshots, WAL recovery, and PITR aren't available unless you set up volume backups or PITR yourself. We don't recover data lost to user-initiated actions. Going forward, enable volume backups on your stateful services so you can self-restore if this happens again.
14 days ago
I did setup a PITR, that’s how everything started. It contained 0 backup so i deleted it. Are you tell me that there’s nothing i can do? Or nothing the support team can do to assist with this? Can export/dump my other project db into this one? If yes, can anyone assist with it, please?
Status changed to Awaiting Railway Response Railway • 14 days ago
14 days ago
Both your Postgres services (Platform-Postgres and App-Postgres) are currently running successfully with their volumes attached and data present. We don't restore data lost to user-initiated actions, but from what we can see, your production databases appear intact - if the data you need is in one of those databases and you want to copy it to the other, you can connect to both using their connection strings (found in each service's Variables tab) and use pg_dump/pg_restore yourself.
Status changed to Awaiting User Response Railway • 14 days ago
Railway
Both your Postgres services (Platform-Postgres and App-Postgres) are currently running successfully with their volumes attached and data present. We don't restore data lost to user-initiated actions, but from what we can see, your production databases appear intact - if the data you need is in one of those databases and you want to copy it to the other, you can connect to both using their connection strings (found in each service's Variables tab) and use `pg_dump`/`pg_restore` yourself.
13 days ago
I did that, i copied the data from platform to app; however, i still can’t log into app.
Status changed to Awaiting Railway Response Railway • 13 days ago
13 days 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 • 13 days ago
persone950
I did that, i copied the data from platform to app; however, i still can’t log into app.
13 days ago
Are there any errors in your Postgres service?