Point in time db recovery

Anvil Q&A
1

Does anyone have a point in time db backup flow working that they can share?

I know I can export the tables as csv files, but it becomes messy especially when you have many links between tables. Currently I keep once-per days csv exports in case of a disaster, but importing them wouldn’t be much fun on account of the many links between tables.

My goal is to keep 7 days of backups, with a backup taken once per day at a scheduled time. I don’t mind storing the backups (even as csv’s) in S3 or some other cloud storage provider, but restoration should be a simple click and boom, we’re back sort of feeling.

I know Anvil offers it as a service on support packages, but I’d sleep better at night if I can do this myself.

2

I’m just going to chime in here and say that if you’re lucky enough to have Anvil Enterprise, this is completely self-service - choose a database, choose a date and time to restore it to, wait a few minutes, and voila - your app has a new DB, cloned from your selected DB at the nominated date and time :slight_smile:

(We would like to make this self-service on the Production Plan at some point. If this is something you’d upgrade for, drop us a line at sales@anvil.works and we’ll see if we can make it happen a little faster!)

1 Like