Postgres Pro
Downloads
Home   >   mailing lists

Re: Clarification on pg_basebackup - Mailing list pgsql-admin

From Jeff Frost
Subject Re: Clarification on pg_basebackup
Date
Msg-id 101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com
Whole thread Raw
In response to Re: Clarification on pg_basebackup  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Clarification on pg_basebackup  (Rajesh Madiwale <rajeshmadiwale65@gmail.com>)
List pgsql-admin
Tree view
That's right.

BTW, rather than rolling your own solution, you probably want to look at a few off the shelf solutions like:




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?    
 


pgsql-admin by date:

Previous
From: Jason Mathis
Date:
Subject: Re: Clarification on pg_basebackup
Next
From: Raj Gandhi
Date:
Subject: format() function with string_agg