Urgent: Lost Postgres Data After Region Change (us-west1 to us-west2)
sasha
HOBBYOP

a year ago

On June 2, my production Postgres database was wiped — before the Cloud to Metal migration — and I hadn’t triggered any redeploy at that time. I’d appreciate it if you could check for any internal logs or alerts around that date that might explain what reinitialized the data directory, and let me know if there’s any snapshot or hidden volume from just before the wipe that could be restored. Also, I’d be grateful for any advice on how to enable alerts or safeguards to prevent unexpected data loss like this in the future.

3 Replies

sasha
HOBBYOP

a year ago

f0906ca0-c156-4119-923e-fc7ac7a17e22


a year ago

Did you have a volume mounted to that data directory?


sasha
HOBBYOP

a year ago

Yes, I had a volume mounted to /var/lib/postgresql/data, and I can see it in the Railway CLI:

Volume: sea-volume attached to Postgres, 226MB used.


Welcome!

Sign in to your Railway account to join the conversation.

Loading...