Will any upcoming release of Postgres have an incremental backup tool
like Oracle's RMAN? Currently, the WAL based archiving requires many
frequent full backups (especially for large databases) as the replay
of a large number of WAL files will take a very long time. We have a
few databases each over 1Tb and are looking for effective
backup/recovery strategies. (Currently..we rely on specific partition
backups via COPY command)...but the process is cumbersome.
RMAN's incremental backup effectively makes every incremental backup a
full backup which is a great time-saver during recovery.