From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Basic Question on Point In Time Recovery |
Date: | 2015-03-11 13:55:56 |
Message-ID: | 20150311135556.GC15037@crankycanuck.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 11, 2015 at 09:40:09AM -0400, Joseph Kregloh wrote:
> Have you looked into Barman? http://www.pgbarman.org/ It does what you
> want. You can take a full daily backup and it keeps track of the WAL files
> to allow for a PITR.
I just had a look at the documentation (and the rest of your mail),
and this doesn't actually seem to do what the OP wanted, which is to
get PITR _per database_ in the same cluster. Upthread someone
suggested a way around this, which is to PITR a cluster to a
known-good point and then pg_dump the target database. But if Barman
can do this automatically, that'd be cool (it's just not in the docs).
Barman does look like a nice convenience package for managing
WAL-shipping type backup installations instead of building one's own
scripts, so this note isn't intended as a criticism of the package.
I'm just not sure it does the thing requested in this case.
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Kregloh | 2015-03-11 14:34:40 | Re: Basic Question on Point In Time Recovery |
Previous Message | Joseph Kregloh | 2015-03-11 13:40:09 | Re: Basic Question on Point In Time Recovery |