Re: Archiving control (a part of synch rep patches) - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Archiving control (a part of synch rep patches)
Date
Msg-id 3f0b79eb0812240204y4757db47pfcbb33f057313ae7@mail.gmail.com
Whole thread Raw
In response to Archiving control (a part of synch rep patches)  ("Fujii Masao" <masao.fujii@gmail.com>)
Responses Re: Archiving control (a part of synch rep patches)  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Hi,

On Wed, Dec 24, 2008 at 4:39 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> (3)
> Revert the arhive status file of the specified file from .done to .ready.
> This would try to archive the corresponding xlog file again. The archive
> status of only skipped xlog file can be reverted.
>
> We resume xlog archiving by using (2) and (3), when replication
> ends.

Umm.. reverting is very tricky, then it might become hotbeds of bugs.
So, I will reconsider the method of resuming archive.

http://archives.postgresql.org/pgsql-hackers/2008-12/msg00723.php
> That conceivably might mean we need
> to write a .ready message after a WAL file filled, which might mean we
> have problems if the replication timeout is longer than the checkpoint
> timeout, but that seems an unlikely configuration. And if anybody has a
> problem with that we just recommend they use the "always" mode.

It's also problem that "reverting" competes with xlog deletion by
checkpoint.

Perhaps we should create .ready after the xlog file fills and it's
replicated during replication. I will consider this course deeply.

Happy Holidays!

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Sync Rep: First Thoughts on Code
Next
From: Simon Riggs
Date:
Subject: Re: Synchronous replication, reading WAL for sending