<div dir="ltr"><div dir="ltr" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">Hi,<div><br></div><div>we have next configuration: </div><div><br></div><div>Many applications connect to 3 pgpool-II with watchdog, 1 pgpool active and 2 pgpool standby.</div><div><br></div><div>We have stopped pgpool active and the applications have taken 40 minutes to reconnect to pgpool.</div><div><br></div><div>Our log is that:</div><div><br></div><div><pre style="white-space:pre-wrap;font-family:Consolas,Menlo,"Liberation Mono",Courier,monospace;margin:1em 1em 1em 1.6em;padding:8px;background-color:rgb(250,250,250);border:1px solid rgb(226,226,226);border-radius:3px;width:auto;overflow-x:auto;overflow-y:hidden;color:rgb(34,34,34);font-size:16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">******************************<wbr>************
old master pgpool (pgpool1) reboot
******************************<wbr>************
2018-02-01 02:28:14: pid 14560: LOG: remote node "pgpool1:30000 Linux pgpool1" is shutting down
...
2018-02-01 02:28:14: pid 14560: LOG: unassigning the remote node "pgpool1:30000 Linux pgpool1" from watchdog cluster master
...
******************************<wbr>************
At this time we can't connecting to the DB
******************************<wbr>************
2018-02-01 02:28:14: pid 14557: ERROR: unable to read data from DB node 0
******************************<wbr>******************
New pgpool (pgpool2) node becomes master
******************************<wbr>******************
2018-02-01 02:28:15: pid 14560: LOG: watchdog node state changed from [INITIALIZING] to [STANDING FOR MASTER]
2018-02-01 02:28:15: pid 14560: LOG: watchdog node state changed from [STANDING FOR MASTER] to [MASTER]
2018-02-01 02:28:15: pid 14560: LOG: I am announcing my self as master/coordinator watchdog node
2018-02-01 02:28:15: pid 14560: LOG: I am the cluster leader node
2018-02-01 02:28:15: pid 14560: LOG: setting the local node "pgpool2:30000 Linux pgpool2" as watchdog cluster master
2018-02-01 02:28:15: pid 14560: LOG: I am the cluster leader node but we do not have enough nodes in cluster
******************************<wbr>*****************************
pgpool node (pgpool3) is adding to the standby list
******************************<wbr>*****************************
2018-02-01 02:28:16: pid 14560: LOG: adding watchdog node "pgpool3:20000 Linux pgpool3" to the standby list
2018-02-01 02:28:16: pid 14560: LOG: quorum found
******************************<wbr>*****************
3 second there is a first connection to the DB
******************************<wbr>*****************
2018-02-01 02:28:17: pid 14560: LOG: new IPC connection received
******************************<wbr>*****************************
pgpool node (pgpool1) is adding to the standby list
******************************<wbr>*****************************
2018-02-01 02:35:17: pid 14560: LOG: new node joined the cluster hostname:"pgpool1" port:30000 pgpool_port:30000</pre><br></div><div>I have any questions:</div><div><br></div><div>¿how it work arping in that case? ¿arping change arptables?</div><div><br></div><div>One of the problem that we have is that VirtualIP not has change from pgpool1 (stop) to pgpool2 (active), then we can connecting from psql in the same network but we cannot connecting from applications. The applications are in other subnet. </div><div><br></div><div>The problem are not the permission because to the 40 minutes the applications can connecting and before stop pgpool1 too.</div><div><br></div><div>Thanks.</div></div><div class="gmail-yj6qo" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"></div><br class="gmail-Apple-interchange-newline"><br></div>