On Wed, May 4, 2016 at 12:38 PM, Dominique Devienne <ddevienne at gmail.com> 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. > I'm talking about logging the source statements that eventually update the database. WAL is a way to keep track of pages after the execution of commands. It's logging text instead of database pages. -- Scott Robison