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

From Trent Shipley
Subject Re: WAL logs multiplexing?
Date
Msg-id 200512281703.07733.tshipley@deru.com
Whole thread Raw
In response to Re: WAL logs multiplexing?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Wednesday 2005-12-28 05:38, 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.
>
> 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...

What if one is off-site?

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: sending mail from Postgres
Next
From: Matthew Hixson
Date:
Subject: Re: importing an Oracle database into Postgres