Re: advanced backup tool

Thanks for the suggestions.

On Fri, May 14, 2010 at 1:28 PM, Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>