On 12/28/05, Dmitry Panov <dmitry@xxxxxxxxxxx> wrote: > On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote: > > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: > > > I'm currently considering setting up online backup procedure and I > > > thought maybe it would be a useful feature if the online logs could be > > > written into more than one place (something like oracle redo logs > > > multiplexing). > > > > > > If I got it right if the server's filesystem crashes completely then the > > > changes that haven't gone into an archived log will be lost. If the logs > > > are written into more than one place the loss could be minimal. > >` When I set up PITR I felt like something was missing. You have to wait for the current log file to be closed before it gets copied off somewhere safe. I think this is something that should be seriously considered if it's not too hard.