Re: WAL logs multiplexing?

From: Dmitry Panov <dmitry(at)tsu(dot)tula(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL logs multiplexing?
Date: 2005-12-28 15:53:49
Message-ID: 1135785229.6858.29.camel@ip6-localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, 2005-12-28 at 10:39 -0500, Tom Lane wrote:
> Dmitry Panov <dmitry(at)tsu(dot)tula(dot)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(at)tsu(dot)tula(dot)ru
Tula State University | Fidonet: Dmitry Panov, 2:5022/5.13
Dept. of CS & NIT | http://www.tsu.tula.ru/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ingo van Lil 2005-12-28 15:56:37 Re: Adding columns to a view
Previous Message Tom Lane 2005-12-28 15:51:18 Re: 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 16:05:16 Re: WAL logs multiplexing?
Previous Message Tom Lane 2005-12-28 15:39:37 Re: WAL logs multiplexing?