<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">I’m migrating my Database cluster to PostgreSQL 14 and have been trying PGPOOL for the Load Balancer feature only.</div><div class=""><br class=""></div><div class="">At the moment I have two servers, and even though PGPOOL and Postgres are up and running on both of them, “show pool_nodes” shows as one of them being down.</div><div class=""><br class=""></div><div class="">server1 pgpool.conf:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><div class=""><span style="font-size: 9px;" class="">listen_addresses = '*'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">port = 9999</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">socket_dir = '/var/run/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">listen_backlog_multiplier = 2</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">serialize_accept = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">reserved_connections = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_listen_addresses = '*'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_port = 9898</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_socket_dir = '/var/run/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_clustering_mode = 'streaming_replication'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_hostname0 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_port0 = 5432</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_weight0 = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_data_directory0 = '/pgsql/14/main'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_flag0 = 'ALLOW_TO_FAILOVER'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_application_name0 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_hostname1 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_port1 = 5432</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_weight1 = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_data_directory1 = '/pgsql/14/main'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_flag1 = 'ALLOW_TO_FAILOVER'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_application_name1 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">enable_pool_hba = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pool_passwd = 'pool_passwd'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">authentication_timeout = 60</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_clear_text_frontend_auth = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">num_init_children = 32</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">max_pool = 4</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">child_life_time = 300</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">child_max_connections = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connection_life_time = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">client_idle_limit = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">syslog_facility = 'LOCAL0'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">syslog_ident = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pid_file_name = '/var/run/postgresql/pgpool.pid'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">logdir = '/var/log/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connection_cache = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">reset_query_list = 'ABORT; DISCARD ALL'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replication_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replicate_select = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">insert_lock = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">lobj_lock_table = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replication_stop_on_mismatch = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_if_affected_tuples_mismatch = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">load_balance_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">ignore_leading_white_space = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">white_function_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">black_function_list = 'currval,lastval,nextval,setval'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">black_query_pattern_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">database_redirect_preference_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">app_name_redirect_preference_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_sql_comments = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">disable_load_balance_on_write = 'transaction'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">statement_level_load_balance = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">master_slave_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">master_slave_sub_mode = 'stream'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_period = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_user = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_database = 'geoop_live'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">delay_threshold = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">follow_master_command = '/etc/pgpool2/follow_primary.sh %d %h %p %D %m %H %M %P %r %R'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_period = 5 # Seconds</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_timeout = 20</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_user = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_database = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_max_retries = 3</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_retry_delay = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connect_timeout = 10000</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_command = '/etc/pgpool2/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failback_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_on_backend_error = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">detach_false_primary = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">search_primary_node_timeout = 300</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">auto_failback = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">auto_failback_interval = 60</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_user = 'pgpoolrecovery'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_1st_stage_command = 'recovery_1st_stage'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_2nd_stage_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_timeout = 90</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">client_idle_limit_in_recovery = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">use_watchdog = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">trusted_servers = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">ping_path = '/bin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_hostname = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_port = 9000</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_priority = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_authkey = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_ipc_socket_dir = '/tmp'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">delegate_IP = '192.168.137.150'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_cmd_path = '/sbin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_up_cmd = '/usr/bin/sudo /sbin/ip addr add $_IP_$/24 dev ens5 label ens5:0'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_down_cmd = '/usr/bin/sudo /sbin/ip addr del $_IP_$/24 dev ens5'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">arping_path = '/usr/sbin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">arping_cmd = '/usr/bin/sudo /usr/sbin/arping -U $_IP_$ -w 1 -I ens5'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">clear_memqcache_on_escalation = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_escalation_command = '/etc/pgpool2/escalation.sh'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_de_escalation_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_when_quorum_exists = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_require_consensus = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_multiple_failover_requests_from_node = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">enable_consensus_with_half_votes = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_method = 'heartbeat'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_interval = 10</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_port = 9694</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_keepalive = 2</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_deadtime = 30</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_destination0 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_destination_port0 = 9694</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_device0 = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_life_point = 3</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_query = 'SELECT 1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_dbname = 'template1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_user = 'nobody'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_pgpool_hostname0 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_pgpool_port0 = 9999</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_wd_port0 = 9000</span></div></div></blockquote><div class=""><br class=""></div><div class="">server2 pgpool.conf:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><div class=""><span style="font-size: 9px;" class="">listen_addresses = '*'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">port = 9999</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">socket_dir = '/var/run/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">listen_backlog_multiplier = 2</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">serialize_accept = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">reserved_connections = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_listen_addresses = '*'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_port = 9898</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pcp_socket_dir = '/var/run/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_clustering_mode = 'streaming_replication'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_hostname0 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_port0 = 5432</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_weight0 = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_data_directory0 = '/pgsql/14/main'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_flag0 = 'ALLOW_TO_FAILOVER'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_application_name0 = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_hostname1 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_port1 = 5432</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_weight1 = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_data_directory1 = '/pgsql/14/main'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_flag1 = 'ALLOW_TO_FAILOVER'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">backend_application_name1 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">enable_pool_hba = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pool_passwd = 'pool_passwd'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">authentication_timeout = 60</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_clear_text_frontend_auth = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">num_init_children = 32</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">max_pool = 4</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">child_life_time = 300</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">child_max_connections = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connection_life_time = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">client_idle_limit = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">syslog_facility = 'LOCAL0'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">syslog_ident = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">pid_file_name = '/var/run/postgresql/pgpool.pid'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">logdir = '/var/log/postgresql'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connection_cache = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">reset_query_list = 'ABORT; DISCARD ALL'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replication_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replicate_select = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">insert_lock = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">lobj_lock_table = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">replication_stop_on_mismatch = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_if_affected_tuples_mismatch = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">load_balance_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">ignore_leading_white_space = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">white_function_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">black_function_list = 'currval,lastval,nextval,setval'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">black_query_pattern_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">database_redirect_preference_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">app_name_redirect_preference_list = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_sql_comments = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">disable_load_balance_on_write = 'transaction'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">statement_level_load_balance = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">master_slave_mode = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">master_slave_sub_mode = 'stream'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_period = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_user = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">sr_check_database = 'geoop_live'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">delay_threshold = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">follow_master_command = '/etc/pgpool2/follow_primary.sh %d %h %p %D %m %H %M %P %r %R'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_period = 5 # Seconds</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_timeout = 20</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_user = 'pgpool'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_database = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_max_retries = 3</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">health_check_retry_delay = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">connect_timeout = 10000</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_command = '/etc/pgpool2/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failback_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_on_backend_error = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">detach_false_primary = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">search_primary_node_timeout = 300</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">auto_failback = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">auto_failback_interval = 60</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_user = 'pgpoolrecovery'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_1st_stage_command = 'recovery_1st_stage'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_2nd_stage_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">recovery_timeout = 90</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">client_idle_limit_in_recovery = 0</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">use_watchdog = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">trusted_servers = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">ping_path = '/bin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_hostname = 'server2'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_port = 9000</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_priority = 1</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_authkey = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_ipc_socket_dir = '/tmp'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">delegate_IP = '192.168.137.150'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_cmd_path = '/sbin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_up_cmd = '/usr/bin/sudo /sbin/ip addr add $_IP_$/24 dev ens5 label ens5:0'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">if_down_cmd = '/usr/bin/sudo /sbin/ip addr del $_IP_$/24 dev ens5'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">arping_path = '/usr/sbin'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">arping_cmd = '/usr/bin/sudo /usr/sbin/arping -U $_IP_$ -w 1 -I ens5'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">clear_memqcache_on_escalation = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_escalation_command = '/etc/pgpool2/escalation.sh'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_de_escalation_command = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_when_quorum_exists = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">failover_require_consensus = on</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">allow_multiple_failover_requests_from_node = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">enable_consensus_with_half_votes = off</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_monitoring_interfaces_list = '' # Comma separated list of interfaces names to monitor.</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_method = 'heartbeat'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_interval = 10</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_port = 9694</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_keepalive = 2</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_heartbeat_deadtime = 30</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_destination0 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_destination_port0 = 9694</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">heartbeat_device0 = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_life_point = 3</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_query = 'SELECT 1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_dbname = 'template1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_user = 'nobody'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">wd_lifecheck_password = ''</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_pgpool_hostname0 = 'server1'</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_pgpool_port0 = 9999</span></div></div><div class=""><div class=""><span style="font-size: 9px;" class="">other_wd_port0 = 9000</span></div></div></blockquote><div class=""><br class=""></div><div class="">Running “show pool_nodes”:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><div class="">postgres@server1:~$ psql -p 9999 -U pgpool postgres -c "show pool_nodes"</div></div><div class=""><div class="">Password for user pgpool:</div></div><div class=""><div class=""> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change</div></div><div class=""><div class="">---------+--------------------------------------------+------+--------+-----------+--------+------------+-------------------+-------------------+-------------------+------------------------+---------------------</div></div><div class=""><div class=""> 0 | server1 | 5432 | down | 0.500000 | slave | 0 | false | 0 | | | 2022-02-01 21:32:24</div></div><div class=""><div class=""> 1 | server2 | 5432 | up | 0.500000 | master | 397 | true | 0 | | | 2022-02-01 21:32:24</div></div><div class=""><div class="">(2 rows)</div></div></blockquote><div class=""><br class=""></div><div class="">What am I missing here? Any help is much appreciated. </div><div class=""><br class=""></div><div class="">Thanks!</div><div class="">Lucas</div></body></html>