From: Stephen Frost <sfrost@snowman.net>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: drum.lucas@gmail.com <drum.lucas@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Incremental Refresh - PostgreSQL 9.2
Date: Wed, 24 Feb 2016 11:31:19 -0500
Message-ID: <20160224163119.GG3127@tamriel.snowman.net> (raw)
In-Reply-To: <CAKFQuwYFoEwQOXwvOuiqx40mJb+T2P3LKKXcTJNKGsX0M+LZ=w@mail.gmail.com>
References: <CAE_gQfUqvmewj91Sg81Orc7S+=aO0xG-xftMB4UycByVEdWHZw@mail.gmail.com>
<CAKFQuwYFoEwQOXwvOuiqx40mJb+T2P3LKKXcTJNKGsX0M+LZ=w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
David,
* David G. Johnston (david.g.johnston@gmail.com) wrote:
> On Tue, Feb 23, 2016 at 2:59 PM, drum.lucas@gmail.com <drum.lucas@gmail.com>
> wrote:
> > Question:
> > Now that the test server has a full copy from master, how could I just do
> > a incremental refreshing once a month?
> >
> > Instead copying all the DB (1.7GB), just copy what has been changed?
> > Is that possible?
> >
> >
> You cannot accomplish incremental updates if your choice of tool is
> pg_dump.
Agreed.
> The only way to do a true incremental would be to rely upon
> something like rsync on the data directory while the master server is
> offline.
pgBackRest actually provides incremental backups and restores and I've
used it for exactly this kind of setup previously.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, david.g.johnston@gmail.com, drum.lucas@gmail.com
Subject: Re: Incremental Refresh - PostgreSQL 9.2
In-Reply-To: <20160224163119.GG3127@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox