15 days ago
Subject: Urgent — accidental data overwrite on Postgres, asking if any snapshot/WAL recovery is possible (Hobby plan, no visible backups)
Project ID: 5f206514-2b5d-4b31-918f-df64bc50626d
Service affected: Postgres (project "ferry-frozen-server")
Environment: production
What happened:
A bug in our application's client caused an unversioned write that overwrote our main data row with empty/default values. The row itself still exists (same key, version counter incremented normally to 1331), but its content is now essentially blank — all the real business data (products, customers, orders, etc.) is gone.
Table: kv_store
Row: key = logistics-business-data-v2, shared = true
Overwritten at: 2026-08-06 14:02:08 UTC
Before that, the row held ~80KB of real data; after, it's ~3.7KB of effectively-empty defaults
I checked the Backups tab and understand backups/PITR are Pro-plan only, so I'm not expecting a self-service restore. What I'm asking is:
Is there ANY way — even manual, even a paid one-off request — to recover the volume/database state from just before 2026-08-06 14:02 UTC? This is a small business's live operational data (inventory, customers, orders, payroll) and losing this past week is a real problem for them.
Happy to provide anything else needed (deployment IDs, more precise timestamps, etc.). Really appreciate any help you can offer here — this is the first time we've hit something like this and I understand backups weren't part of our plan, but wanted to ask before giving up on it.
Thanks for your time.
1 Replies
15 days ago
We don't offer data restoration for user-initiated actions like this. Going forward, upgrading to Pro unlocks native volume backups on your service so it can self-restore if this happens again.
Status changed to Awaiting User Response Railway • 15 days ago
8 days 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 • 8 days ago