Postgres data lost after deployment incident - volume still attached
juliendelmasjr-cloud
HOBBYOP

22 days ago

Hi everyone,

I'm running an n8n instance on Railway with a Postgres database. After a deployment incident yesterday, my Postgres database appears to have been reinitialized — all my n8n workflow data is gone (workflows, credentials, execution history).

Here's what I know:

The volume (postgres-volume) is still attached to the service

n8n connects successfully via internal networking but finds 0 workflows

The TCP public proxy for this Postgres stopped accepting connections

I also have a second Postgres service (Postgres-VN6e) in the project — it has the n8n schema (91 tables) but also 0 data

I'm not on the Pro plan, so I don't have automatic backups

It seems like the database was wiped during a redeployment, but the volume is still there.

Has anyone experienced something similar? Is there any way to recover data from an existing volume after a DB reinitialization? Or can the Railway team help with volume-level recovery?

Any help appreciated. Thanks!

Solved

3 Replies

Railway
BOT

22 days ago

Unfortunately, we do not offer data recovery for database services, as they are unmanaged and we do not maintain internal snapshots, WAL archives, or point-in-time recovery unless you explicitly enable it. Both your Postgres services show successful deployments with the volume still attached, so the data on the volume was likely overwritten when Postgres reinitialized into what it saw as an empty data directory. Going forward, we strongly recommend enabling volume backups on your Postgres service (available on Hobby) and considering Point-in-Time Recovery so you can self-restore in the future.


Status changed to Awaiting User Response Railway 22 days ago


Railway

Unfortunately, we do not offer data recovery for database services, as they are unmanaged and we do not maintain internal snapshots, WAL archives, or point-in-time recovery unless you explicitly enable it. Both your Postgres services show successful deployments with the volume still attached, so the data on the volume was likely overwritten when Postgres reinitialized into what it saw as an empty data directory. Going forward, we strongly recommend enabling [volume backups](https://docs.railway.com/volumes/backups) on your Postgres service (available on Hobby) and considering [Point-in-Time Recovery](https://docs.railway.com/volumes/point-in-time-recovery) so you can self-restore in the future.

juliendelmasjr-cloud
HOBBYOP

22 days ago

Hi, thank you for the quick response.

I understand that data recovery isn't part of your standard offering. However, since the volume is still attached and was never deleted, is there truly no way to inspect its contents at a lower level? Even a read-only mount or a raw snapshot of the volume would help — I could attempt recovery myself if given access to the underlying data.

If that's definitively not possible, I'll accept the loss and move forward. Just want to make sure I've exhausted every option before rebuilding from scratch.

Thanks again for your time.


Status changed to Awaiting Railway Response Railway 22 days ago


Railway
BOT

22 days ago

There is no way to inspect volume contents outside of the mounted service, and we don't offer read-only mounts, raw snapshots, or any form of volume-level data recovery. The only access path to a volume is through the service it's attached to, so if Postgres reinitialized over the existing data directory, that data is no longer recoverable. Going forward, you can enable volume backups from the Backups tab on your Postgres service to protect against this in the future.


Status changed to Awaiting User Response Railway 22 days ago


Status changed to Solved Railway 22 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...