> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
