Anj Adu wrote:
> 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.
Sure, look at pg-rman:
http://code.google.com/p/pg-rman/
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
