Re: WAL logs multiplexing? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: WAL logs multiplexing?
Date
Msg-id 20051228123814.GD24400@svana.org
Whole thread Raw
In response to WAL logs multiplexing?  (Dmitry Panov <dmitry@tsu.tula.ru>)
Responses Re: WAL logs multiplexing?
Re: WAL logs multiplexing?
List pgsql-general
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.

So you think PostgreSQL should reimplement something that RAID
controllers already do better?

These are reasons you have backups and PITR and other such things. I
don't think having the server log to multiple places really gains you
anything...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Automatic recovery process
Next
From: Vilen Tambovtsev
Date:
Subject: DB crash after disk full