[Pgpool-general] Does pgpool II support manual failover?

[Zhidong She]

Thanks very much, pcp_detache_node works well and can trigger the third node
to failover.

Here comes the new question, :)
If the failure database backend (which is the original master node 0) comes
back, is it possible to add it back to pgpool as a slave backend?
I tried pcp_attached_node to attach the node 0 back, but pgpool will regard
the node 0 as master again and forword all requests to node 0.
I also tried to change the pgpool.conf to swap the ip of host0 and host1,
and ask pgpool to reload the config, but it does not work.

I know I can change the configure file and restart the pgpool, but maybe
there's other tricky without restart pgpool.

Any suggestions?

Thanks again for your time!

Regards,
Zhidong

On Mon, Dec 13, 2010 at 5:06 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Hi all,
> >
> > I have several questions about pgpool, we plan to use pgpool plus slony
> to
> > build a HA solution for our project, master backend and slave backend are
> > synchronized by slonyI.
> > We may have more than 1 pgpool nodes, for example 3 pgpool node. If two
> > pgpool nodes loss connection to master backend (not master node failure),
> we
> > will trigger slave backend to be promoted as master node.
> > At the same time, we need notify the third pgpool(it works fine) to do a
> > failover.
> >
> > We can ssh to the third node, but how to trigger the third pgpool node to
> do
> > the failover?
>
> I havn't tried yet but I think you could use pcp_command to force the
> third pgpool node detach the failed master backend.
>
> > The second question, it seems that for the master/slave configuration,
> the
> > pgpool will always failover if any node failed. Can it be configured as
> > doing failover if and only if the master node failure?
>
> This is not currently possible but I have a plan to add the
> functionality for the next release.  I have received same request from
> other users.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > Thanks very much for you time. You will be highly appreciated if have any
> > sugguestion.
> > Br,
> > Zhidong
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101214/7fee8427/attachment.html>