Re: WAL logs multiplexing?

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL logs multiplexing?
Date: 2005-12-28 15:07:54
Message-ID: 725602300512280707x1b627cadgc2f11d6daf96df26@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 12/28/05, Dmitry Panov <dmitry(at)tsu(dot)tula(dot)ru> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-12-28 15:39:37 Re: WAL logs multiplexing?
Previous Message Frank van Vugt 2005-12-28 14:46:23 just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-28 15:35:19 plperl vs LC_COLLATE (was Re: Possible savepoint bug)
Previous Message Dmitry Panov 2005-12-28 13:06:58 Re: WAL logs multiplexing?