On Thu, Sep 16, 2010 at 1:23 PM, Fujii Masao <masao.fu...@gmail.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
pg_trigger_failover_v2.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers