David, * David G. Johnston (david.g.johnston@xxxxxxxxx) wrote: > On Tue, Feb 23, 2016 at 2:59 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> > 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
Attachment:
signature.asc
Description: Digital signature
