Thanks for the suggestions.
On Fri, May 14, 2010 at 1:28 PM, Bruce Momjian <bruce@momjian.us> wrote:
> 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
>