accidental data overwrite on Postgres
ferryfrozenfff
FREEOP

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.

Solved

1 Replies

Railway
BOT

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


Railway
BOT

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


Welcome!

Sign in to your Railway account to join the conversation.

Loading...