What’s the best practice for setting up scheduled backups in managed-postgres? It looks like I can create one-off backups on demand in the web console, but I don’t see any backup-related commands in the CLI.
It appears that there might be a scheduled daily full backup running, but I don’t see any way to edit the schedule and/or confirm.
Thanks for the information. The web console I can see doesn’t show most of the backups you mentioned - all I can see is a full backup 20 hours ago, which is roughly when I created the database cluster.
I was hoping to be able to fulfill a 10 minute recovery point objective, although that number was mostly just because that’s what our current provider delivers. One hour should be fine for our uses.
However, as far as I can tell, the schedule you mentioned isn’t running, and I’m not sure how I can restore a backup if they aren’t showing up in the web console and there aren’t any CLI commands for making backups or restoring them? Am I missing something important?
We’ve detected a simple SQL mistake when scheduling backups that would miss a few clusters. Im implementing and sending the fix to production! Thanks for pointing that out.