pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedadvanced backup tool
5+ messages / 4 participants
[nested] [flat]
* advanced backup tool
@ 2010-05-14 20:12 Anj Adu <fotographs@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: Anj Adu @ 2010-05-14 20:12 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: advanced backup tool
@ 2010-05-14 20:17 Joshua D. Drake <jd@commandprompt.com>
parent: Anj Adu <fotographs@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2010-05-14 20:17 UTC (permalink / raw)
To: Anj Adu <fotographs@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: advanced backup tool
@ 2010-05-14 20:20 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Anj Adu <fotographs@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2010-05-14 20:20 UTC (permalink / raw)
To: Anj Adu <fotographs@gmail.com>; 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: advanced backup tool
@ 2010-05-14 20:28 Bruce Momjian <bruce@momjian.us>
parent: Anj Adu <fotographs@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2010-05-14 20:28 UTC (permalink / raw)
To: Anj Adu <fotographs@gmail.com>; +Cc: pgsql-admin
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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: advanced backup tool
@ 2010-05-14 20:43 Anj Adu <fotographs@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 5+ messages in thread
From: Anj Adu @ 2010-05-14 20:43 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin
Thanks for the suggestions.
On Fri, May 14, 2010 at 1:28 PM, Bruce Momjian <bruce@momjian.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@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-05-14 20:43 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-14 20:12 advanced backup tool Anj Adu <fotographs@gmail.com>
2010-05-14 20:17 ` Joshua D. Drake <jd@commandprompt.com>
2010-05-14 20:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-05-14 20:28 ` Bruce Momjian <bruce@momjian.us>
2010-05-14 20:43 ` Anj Adu <fotographs@gmail.com>
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