Re: Incremental Refresh - PostgreSQL 9.2 - Mailing list pgsql-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