Re: Clarification on pg_basebackup

On Tue, Sep 23, 2014 at 10:14 PM, Jeff Frost <jeff(at)pgexperts(dot)com> wrote:

> That's right.
>

Postgres ignore duplicate WAL file so we can recover the data without
using -X option while performing pg_basebackup.

>
> 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(at)illinois(dot)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?
>
>
>
>
>