Thread: RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)
> > > > 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
"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 ?
> > > 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 ? Backup And Restore. Vadim
At 07:05 PM 11/19/00 +0100, devik@cdi.cz wrote: >Cam I ask what BAR is ? Backup and recovery, presumably... - Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Serviceand other goodies at http://donb.photo.net.