Re: advanced backup tool - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: advanced backup tool
Date
Msg-id 1273868241.2455.70.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to advanced backup tool  (Anj Adu <fotographs@gmail.com>)
List 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



pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: Re: advanced backup tool
Next
From: "Narasimha Murthy-VRFX87"
Date:
Subject: Clarification Needed: When does autovacuum daemon run?