| From: | Jeff Frost <jeff(at)pgexperts(dot)com> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | Jason Mathis <jmathis(at)redzonesoftware(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Clarification on pg_basebackup |
| Date: | 2014-09-23 16:44:39 |
| Message-ID: | 101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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(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?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raj Gandhi | 2014-09-24 02:17:08 | format() function with string_agg |
| Previous Message | Jason Mathis | 2014-09-23 16:38:24 | Re: Clarification on pg_basebackup |