Feature request

[skorvek]

My use case would be to use this script for intraday ("hourly") backups for a postgres instance running on a VM. However there is no option for hourly backup configuration- the smallest grain is daily.

The entire VM is already being backed up daily which integrates nicely with my existing backup scheme and rotation. But I would like to back up a select few databases more frequently, storing the backup files in the VM (so those get backed up on the regular VM backup schedule with matching retention schedule). I would only retain < 1 day's worth of backups on the VM itself. This option would greatly simplify an emergency restore of a single database in the server (vs cloning the entire VM, connecting to it, exporting the desired DB, then relaunching the production VM and restoring the single DB file) and would save VM backup space and bandwidth as currently to achieve this I need to backup the entire VM on an intraday basis.

Note this is very different from high availability/failover or WAL shipping (far more complex than a simple frequent pgdump vis this script).

Thanks.

[k0lter]

Hi @skorvek

Thanks for the suggestion.

I guess that it could be feasible but it will require some work. I will try to keep this in mind.

Thanks.