[pgpool-general: 4943] Pgpool New master failover issues

Vaidyanathaswamy, Sai (NBCUniversal) Sai.Vaidyanathaswamy at nbcuni.com
Tue Aug 23 15:06:45 JST 2016


Dear Support help,

We are evualating  the pgpool II for high availability with load balancing  ,  We are not able to proceed further due to auto failover issues.
We have built the pgpool 3.5 with postgres 9.5 version  with Master/slave configuration , I am able to perform the following


  *   Master > slave, Slave promoted as master through auto failover
  *   Vice versa, I am not able to promote the old master to primary after shutting down the slave/master.
  *   I have placed the masterfoward.sh script and placed the scripts in the directory with the path in pgpool.conf
  *   Pgpool not able to execute the auto failover vice versa, I have modified the required parameters to call master forward scripts.
  *   Load balancing performed through background_wight

My question is,


  1.  Will pgpool support vice versa failover?
  2.  Is there any parameters need to tweak for vice versa failover?
  3.  How to perform the pgpool connection pooling?

Your help is much appreciated.

Thanks !
sai
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160823/87b16c08/attachment.html>


More information about the pgpool-general mailing list