Scheduled backups in managed-postgres

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.

Howdy. We schedule managed postgres backups in the following way (UTC):

  • Daily full backups at 1AM
  • Differential backups each 6th hour
  • Incremental backups each hour

All of them happen at minute 0 of their respective hours.

At the moment we didnt setup any customizations for that.

Can I ask what you’re looking for when customizing backups? Your feedback will help us push the MPG platform further.

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?

You’re correct. Im currently looking why your cluster did not get the the scheduled backups right now :eye:

1 Like

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.

1 Like

Thank you. Do you have an estimate for how long it might take for the fix to go live?

I gander a few minutes to pass our CI and be deployed.

1 Like

Awesome!

Should be live in a few + some time to go through the queue of MPGs

It appears to have processed a queue of backup requests. :slight_smile:

Thanks!