8 days ago
I ran an SQL command on Saturday morning to delete inactive users from my database. Unfortunately, it also included 131 users that i did not mean to delete. Please help me, this is an emergency!
5 Replies
8 days ago
We don't offer data restoration for user-initiated actions like this. Going forward, enable volume backups on your service so you can self-restore if it happens again.
Status changed to Awaiting User Response Railway • 8 days ago
Railway
We don't offer data restoration for user-initiated actions like this. Going forward, enable volume backups on your service so you can self-restore if it happens again.
8 days ago
Please I just need to restore from a snapshot, I'll upgrade to the pro plan if necessary. This was a huge mess up on my part.
Status changed to Awaiting Railway Response Railway • 8 days ago
8 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 • 8 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.
8 days ago
Please could you help me with this then?
CREATE EXTENSION IF NOT EXISTS pg_dirtyread;
i beleive i can restore the data this way
Status changed to Awaiting Railway Response Railway • 8 days ago
8 days ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • 8 days ago
rdevans31
Please could you help me with this then? CREATE EXTENSION IF NOT EXISTS pg_dirtyread; i beleive i can restore the data this way
8 days ago
You can run SQL queries through the Database or Console tab of your service.