> > > > 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

Thu, 16 Nov 2000 13:31:54 -0800
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c
 xlog.c)
"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 ?


Sun, 19 Nov 2000 19:05:18 +0100
devik@cdi.cz
Re: RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)
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 Service and other goodies at
  http://donb.photo.net.

Sun, 19 Nov 2000 10:37:43 -0800
Don Baccus <dhogaza@pacifier.com>
Re: RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c
  xlog.c)
> > > 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



Sun, 19 Nov 2000 11:26:56 -0800
"Vadim Mikheev" <vmikheev@sectorbase.com>
Re: RE: [COMMITTERS] pgsql/src/backend/access/transam (xact.c xlog.c)