Hi, When I gave my talk on pg_basebackup at pgconf.eu, people took the opportunity to mention various improvements which they would find useful. One of those improvements was the ability to combine several incremental backups into one. This might be useful if you take very frequent incremental backups but want to roll up older ones to reduce storage requirements. For example, you could take an incremental backup every hour, but then once more than a day has gone by, you might roll up those up six at a time into bigger incremental backups so that you store 4 backups per day instead of 24 backups per day.
The attached patch set lets you do this. I have only tested it a
little bit, and before it gets committed, it needs substantially more
testing, as well as code review. I plan to write some TAP tests to
include in the patch, too, but I haven't done that yet. The idea is
that instead of doing this:
$ pg_combinebackup full incr1 incr2 incr3 incr4 incr5 -o result
You could instead do this:
$ pg_combinebackup -i incr1 incr2 incr3 -o incr1-3
$ rm -rf incr{1,2,3}
<time passes>
$ pg_combinebackup full incr1-3 incr5 -o result
If you're interested in this feature, please give this a try and let
me know what you find out!
Thanks,
--
Robert Haas
EDB: http://www.enterprisedb.com
v1-0001-pg_combinebackup-Factor-some-code-out-of-write_re.patch
Description: Binary data
v1-0002-pg_combinebackup-Add-a-incremental-option.patch
Description: Binary data
