From: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
---|---|
To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Basic Question on Point In Time Recovery |
Date: | 2015-03-11 14:34:40 |
Message-ID: | CAAW2xffeX6jjOeBpq0-6Hz1HbTgosh5pPNznphk3FT+wOZ1ZAg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 11, 2015 at 9:55 AM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
wrote:
> 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.
This is where Barman comes in. It would take care of handling all of the
stuff required for a PITR. Then he can do the pg_dump for a selected
database. Barman does backup the entire cluster.
> 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | pinker | 2015-03-11 15:52:23 | Re: VACUUM FULL doesn't reduce table size |
Previous Message | Andrew Sullivan | 2015-03-11 13:55:56 | Re: Basic Question on Point In Time Recovery |