"Mikheev, Vadim" wrote:
>
> > > > > No. Checkpoints are to speedup after crash recovery and
> > > > > to remove/archive log files. With WAL server doesn't write
> > > > > any datafiles on commit, only commit record goes to log
> > > > > (and log fsync-ed). Dirty buffers remains in memory long
> >
> > Ok, so with CHECKPOINTS, we could move the offline log files to
> > somewhere else so that we could archive them, in my
> > undertstanding. Now question is, how we could recover from disaster
> > like losing every table files except log files. Can we do this with
> > WAL? If so, how can we do it?
>
> Not currently. WAL based BAR is required. I think there will be no BAR
> in 7.1, but it may be added in 7.1.X (no initdb will be required).
> Anyway BAR implementation is not in my plans. All in your hands, guys -:)
>
> Vadim
Cam I ask what BAR is ?
