On Tue, Sep 23, 2014 at 10:14 PM, Jeff Frost <jeff@xxxxxxxxxxxxx> 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/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?
