Is there a way to protect PG backups (from volume wipe)
tlonny
PROOP

5 months ago

We wonder if there is a way to protect PG backups from getting removed when a volume is wipe. I'm often wiping test environment volumes and god-forbid I accidentally wipe prod only to discover backups are gone too…

It seems like as of now, if a volume is wiped - backups are gone too.

7 Replies

passos
MODERATOR

5 months ago

seems like it's not possible, had the same issue as you
https://discord.com/channels/713503345364697088/1415637098727473233
consider sharing your use case there


tlonny
PROOP

5 months ago

Thanks @ThallesComH - could Railway staff provide a suggestion for a workaround? Periodic copying of a volume to another volume every 24hr? Would that work?


passos
MODERATOR

5 months ago

I would suggest doing a backup offsite using a template like this one:
https://railway.com/deploy/I4zGrH


tlonny
PROOP

5 months ago

thanks mate


tlonny
PROOP

5 months ago

ack


rayrift
HOBBY

5 months ago

To be honest you should not have your prod db on railway. I know it will offend the moderators but as good as railway is the UI and DX is also equally good it's very easy to wipe out or delete your prod db's or volumes attached to your db because of this simple UI.

There should be some kind of mechanism for deletion maybe 2FA for sensitive services like db or prod backend.


passos
MODERATOR

5 months ago

Railway does require 2FA if you've enabled it but I can see the problem if the user does not have it enabled, would be nice to require 2FA for any team member like other platforms offers, will open a feedback thread about it


Loading...