Re: Latches, signals, and waiting

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Latches, signals, and waiting
Date: 2010-09-16 05:05:06
Message-ID: AANLkTimuHbxbuM+zLkaEX3aDqSeiMUE3xb4ww1QtsLmf@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Thu, Sep 16, 2010 at 1:23 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> Fujii-san suggested that we might have a user-defined function for
>> triggering failover as well.
>
> The attached patch introduces such a user-defined function. This is
> useful especially when clusterware like pgpool-II is located in remote
> server since it can trigger failover without using something like ssh.

I forgot to check if the caller of that function has superuser permission.
Here is the updated version.

Regards,

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

Attachment Content-Type Size
pg_trigger_failover_v2.patch application/octet-stream 10.5 KB

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2010-09-16 14:31:20 pgsql: Fix bad grammar.
Previous Message Fujii Masao 2010-09-16 04:47:52 Re: Latches, signals, and waiting

Browse pgsql-hackers by date

  From Date Subject
Next Message Hitoshi Harada 2010-09-16 05:35:09 Re: patch: SQL/MED(FDW) DDL
Previous Message Fujii Masao 2010-09-16 04:47:52 Re: Latches, signals, and waiting