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
