pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?    
>  

view thread (7+ messages)  latest in thread

Message-ID: <101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com>
Permalink:  ../101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com/
Also on:    postgresql.org/message-id/101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com

 · 

reply

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