From: Joshua D. Drake <jd@commandprompt.com>
To: Anj Adu <fotographs@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: advanced backup tool
Date: Fri, 14 May 2010 13:17:21 -0700
Message-ID: <1273868241.2455.70.camel@jd-desktop.unknown.charter.com> (raw)
In-Reply-To: <AANLkTinICd7IIuTRDboK9YN6L4o0zYZ4FIAKrIaoMYIO@mail.gmail.com>
References: <AANLkTinICd7IIuTRDboK9YN6L4o0zYZ4FIAKrIaoMYIO@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, fotographs@gmail.com
Subject: Re: advanced backup tool
In-Reply-To: <1273868241.2455.70.camel@jd-desktop.unknown.charter.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox