Re: Clarification on pg_basebackup

[Jeff Frost <jeff@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxx> 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?