Re: Incremental Refresh - PostgreSQL 9.2

David,

* David G. Johnston (david(dot)g(dot)johnston(at)gmail(dot)com) wrote:
> On Tue, Feb 23, 2016 at 2:59 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)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