Re: advanced backup tool

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: advanced backup tool
Date: 2010-05-14 20:17:21
Message-ID: 1273868241.2455.70.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2010-05-14 at 13:12 -0700, 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.

We accept patches, donations and sponsorship opportunities :)

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2010-05-14 20:18:35 Re: List traffic
Previous Message Anj Adu 2010-05-14 20:12:58 advanced backup tool