<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hello! I noticed the value in the load_balance_node column keeps switching between &quot;true&quot; and &quot;false&quot; for both nodes, even there&#39;s no change in the Postgres&#39;s availability.</div><div dir="ltr"><br></div><div>Is it indicating any configuration problems?</div><div><br></div><div># pgpool.conf</div><div><div>backend_hostname0 = &#39;<a href="http://hoopa-uat-1.sg.m-daq.net">hoopa-uat-1.sg.m-daq.net</a>&#39;</div><div>backend_port0 = 5432</div><div>backend_weight0 = 1</div><div>backend_data_directory0 = &#39;/var/lib/pgsql/11/data&#39;</div><div>backend_flag0 = &#39;ALWAYS_MASTER&#39;</div><div><br></div><div>backend_hostname1 = &#39;<a href="http://hoopa-uat-2.sg.m-daq.net">hoopa-uat-2.sg.m-daq.net</a>&#39;</div><div>backend_port1 = 5432</div><div>backend_weight1 = 1</div><div>backend_data_directory1 = &#39;/var/lib/pgsql/11/data&#39;</div><div>backend_flag1 = &#39;ALLOW_TO_FAILOVER&#39;</div></div><div><br></div><div dir="ltr"><div># output for &quot;show pool_nodes&quot;</div><div><div><font face="monospace, monospace">[postgres@hoopa-uat-1 data]$ psql -h <a href="http://hoopa-uat-pgpool-1.sg.m-daq.net">hoopa-uat-pgpool-1.sg.m-daq.net</a> -p 5432 -U postgres -c &quot;show pool_nodes&quot; postgres</font></div><div><font face="monospace, monospace">show pool_nodes</font></div><div><font face="monospace, monospace"> node_id |         hostname         | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | last_status_change</font></div><div><font face="monospace, monospace">---------+--------------------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------</font></div><div><font face="monospace, monospace"> 0       | <a href="http://hoopa-uat-1.sg.m-daq.net">hoopa-uat-1.sg.m-daq.net</a> | 5432 | up     | 0.500000  | primary | 48         | true              | 0                 | 2018-11-27 11:54:06</font></div><div><font face="monospace, monospace"> 1       | <a href="http://hoopa-uat-2.sg.m-daq.net">hoopa-uat-2.sg.m-daq.net</a> | 5432 | up     | 0.500000  | standby | 51         | false             | 0                 | 2018-11-27 11:54:06</font></div><div><font face="monospace, monospace">(2 rows)</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">[postgres@hoopa-uat-1 data]$ psql -h <a href="http://hoopa-uat-pgpool-1.sg.m-daq.net">hoopa-uat-pgpool-1.sg.m-daq.net</a> -p 5432 -U postgres -c &quot;show pool_nodes&quot; postgres</font></div><div><font face="monospace, monospace">show pool_nodes</font></div><div><font face="monospace, monospace"> node_id |         hostname         | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | last_status_change</font></div><div><font face="monospace, monospace">---------+--------------------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------</font></div><div><font face="monospace, monospace"> 0       | <a href="http://hoopa-uat-1.sg.m-daq.net">hoopa-uat-1.sg.m-daq.net</a> | 5432 | up     | 0.500000  | primary | 48         | false             | 0                 | 2018-11-27 11:54:06</font></div><div><font face="monospace, monospace"> 1       | <a href="http://hoopa-uat-2.sg.m-daq.net">hoopa-uat-2.sg.m-daq.net</a> | 5432 | up     | 0.500000  | standby | 51         | true              | 0                 | 2018-11-27 11:54:06</font></div><div><font face="monospace, monospace">(2 rows)</font></div></div><div><br></div><div><br></div><div>Thank you.</div><div><br></div><div>Regards,</div><div>Mike Yeap</div></div></div></div></div>