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

From Dmitry Panov
Subject Re: WAL logs multiplexing?
Date
Msg-id 1135785229.6858.29.camel@ip6-localhost
Whole thread Raw
In response to Re: WAL logs multiplexing?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WAL logs multiplexing?
List pgsql-general
On Wed, 2005-12-28 at 10:39 -0500, Tom Lane wrote:
> Dmitry Panov <dmitry@tsu.tula.ru> writes:
> > 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).
>
> You can do whatever you want in the archive_command script.
>

Yes, but if the server has crashed earlier the script won't be called
and if the filesystem can't be recovered the changes will be lost. My
point is the server should write into both (or more) files at the same
time.


Best regards,
--
Dmitry O Panov          | mailto:dmitry@tsu.tula.ru
Tula State University   | Fidonet: Dmitry Panov, 2:5022/5.13
Dept. of CS & NIT       | http://www.tsu.tula.ru/



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?
Next
From: Ingo van Lil
Date:
Subject: Re: Adding columns to a view