Re: advanced backup tool - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: advanced backup tool
Date
Msg-id 4BED6A5B02000025000317B0@gw.wicourts.gov
Whole thread Raw
In response to advanced backup tool  (Anj Adu <fotographs@gmail.com>)
List pgsql-admin
Anj Adu <fotographs@gmail.com> 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.

I don't know how well this will fit, but we crafted our own solution
for similar issues with a few simple bash scripts.  The approach is
described prospectively here:

http://archives.postgresql.org/pgsql-admin/2009-03/msg00233.php

with a follow-up here:

http://archives.postgresql.org/pgsql-admin/2009-07/msg00071.php

I hope that is helpful.

-Kevin

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: advanced backup tool
Next
From: Bruce Momjian
Date:
Subject: Re: advanced backup tool