From: Jeff Frost <jeff@pgexperts.com>
To: Campbell, Lance <lance@illinois.edu>
Cc: Jason Mathis <jmathis@redzonesoftware.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Clarification on pg_basebackup
Date: Tue, 23 Sep 2014 09:44:39 -0700
Message-ID: <101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D701FBB759B@CITESMBX1.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D701FBB7279@CITESMBX1.ad.uillinois.edu>
<etPan.54219a5f.2eb141f2.14be7@palos>
<B75CD08C73BD3543B97E4EF3964B7D701FBB759B@CITESMBX1.ad.uillinois.edu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
That's right.
BTW, rather than rolling your own solution, you probably want to look at a few off the shelf solutions like:
Barman: http://www.pgbarman.org/
WAL-E: https://github.com/wal-e/wal-e
On Sep 23, 2014, at 9:18 AM, Campbell, Lance <lance@illinois.edu> wrote:
> Jason,
> Thanks so much. That makes sense. That was what I was trying to communicate. OPIT vs APIT.
>
> So if I am doing a APIT I can do a pg_basebackup each night without the –X option. I save all WAL files. If I need to restore during the day I then only have to restore from the last basebackup and apply all of the WAL files from that time forward. Did I get that correct?
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jeff@pgexperts.com, lance@illinois.edu, jmathis@redzonesoftware.com
Subject: Re: Clarification on pg_basebackup
In-Reply-To: <101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com>
References: <B75CD08C73BD3543B97E4EF3964B7D701FBB7279@CITESMBX1.ad.uillinois.edu> <etPan.54219a5f.2eb141f2.14be7@palos> <B75CD08C73BD3543B97E4EF3964B7D701FBB759B@CITESMBX1.ad.uillinois.edu> <101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.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