On 2016/05/04 8:38 PM, Dominique Devienne wrote: > On Wed, May 4, 2016 at 5:51 PM, Scott Robison <scott at casaderobison.com> > wrote: > >>>> This is going to become a bigger problem for us as the database will >>>> only get bigger so any advice welcomed. >> Perhaps, rather than backing up the live data, you create an append only >> log of each and every query you send to the database. Should you need to >> restore, you replay the log of statements. >> > That sounds like WAL to me, except done manually. > > In fact, if there was a hook during checkpointing that allowed to grab > parts of WAL file, > and apply these chunks (aligned with transactions or savepoints) to another > DB, > you'd basically have online replication with minimal overhead. --DD
Quite correct, but isn't that what the RBU extension basically achieved, only in a well-managed and safe way? I haven't used it yet, but am planning to....