[pgpool-general: 4496] Re: follow_master in case the old master does not have network connectivity.

[Travis Kirstine]

I'm somewhat new to pgpool myself so this may be wrong but my understanding is that when a node (master or standby) fails pgpool marks that node as offline.  When the issue with the failed node is resolved you must re-attach the node to bring it back into the cluster using the pcp_attach_node command


pcp_attach_node 10 localhost 9898 user password node_id


There may be a method to handle this automatically but I don't know it.


Regards



________________________________
From: pgpool-general-bounces at pgpool.net <pgpool-general-bounces at pgpool.net> on behalf of Avi Weinberg <AviW at gilat.com>
Sent: Thursday, February 25, 2016 10:20 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4495] follow_master in case the old master does not have network connectivity.

Hi all,

If I understood correctly follow_master is called immediately after old master fails and new master is promoted.  However, what if there is no connection to old master and the connection resumes after few minutes.  Will follow_master will be executed then?.  Is there an automatic way to make the old master into a slave if the old master machine is reconnected only after an extended period of time?  Who should monitor the old master connectivity?

Thanks for all the assistance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160225/3fa6b06d/attachment.html>