Re: Synchronous replication: Promotion of Standby to Primary

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: "K, Niranjan (NSN - IN/Bangalore)" <niranjan(dot)k(at)nsn(dot)com>
Cc: "Kolb, Harald (NSN - DE/Munich)" <harald(dot)kolb(at)nsn(dot)com>, "Czichy, Thoralf (NSN - FI/Helsinki)" <thoralf(dot)czichy(at)nsn(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Synchronous replication: Promotion of Standby to Primary
Date: 2009-05-14 11:16:51
Message-ID: 3f0b79eb0905140416t72792a8cr6568fce92f8c448e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, May 4, 2009 at 11:07 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan(dot)k(at)nsn(dot)com> wrote:
> Hi,
>
> Re-opening the discussion related to triggers to promote standby server.
> In the earlier dicussion, there were 2 proposals, Trigger based on file
> and trigger based on signals. I think there was no conclusion on this.
> http://archives.postgresql.org/pgsql-hackers/2008-12/msg01231.php
>
> According to the proposal, it seems to be better if signals are used as
> we can avoid checking the file existance in the loop. Or the other
> approach is to use inotify (http://en.wikipedia.org/wiki/Inotify) But
> portability to other unix like OS is an issue to look for.
>
> Could you please get back which is being implemented/ considered for
> promotion of standby?

I had to choose the trigger file approach last time since the patch
was also using warm-standby in part. But, in 8.5, synch-rep is
going to work without warm-standby. So, we can choose also the
trigger based on signals. In this case,

Since using kill(1) command directly for the trigger signal is troublesome,
we should also provide the wrapper command such as "pg_ctl trigger/promote".

Regards,

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2009-05-14 11:39:03 Re: Synchronous replication: Promotion of Standby to Primary
Previous Message Dimitri Fontaine 2009-05-14 10:35:00 Re: Problem with estimating pages for a table