<div dir="ltr"><div>Hello Guys:<br></div>i have posted this issue in pgpool-Users, but i got no answer. At this point i am thinking about switching solutions as i cannot make mine work, but i really like the idea of using pgpool, so i was wondering if i could get an answer here. This is the issue i am experiencing:<br><br>I am running pgpool 3.5.2 in a 2 node cluster with postgresql-9.5 in master-slave and streaming replication mode.<br><br>I
have been testing failover and failback for a while. While doing
failover by shutting down the processes, everything looks fine.<br><br><br><div>The one test that is failing is when i shutdown the interface of one node.<br></div><div>Right now i am shutting down the interface of the slave node (both pgool slave and postgresql slave).<br><br></div><div>The
problem i am running into is that after doing this, all connections to
my database (through pgpool) hang. i am testing it with psql, and psql
just hangs and does not give me an output. When i bring the interface of
the slave back up, and try to connect to psql again, it looks like
pgpool never marked the postgresql node as disconnected. <br><br></div><div>I
tried both with and without health check, and also tried with different
values of health_check_timeout. my connect timeout value is default (10
seconds).<br><br></div><div>Any one has encountered this issue? I just
dont see pgpool attempting to do any failover. Pgpool is still running
though, i can see the logs still comming. I just never see an error.<br><br></div><div>I am NOT using interface monitoring, and i would prefer not to use it.<br><br></div>Any pointers on how could i troubleshoot this?<br></div>