<div dir="ltr">Hello all,<br><br>First of all, thank you for making such a unique software! I'm using pgpool with AWS RDS on AWS EKS with the following pgpool.conf configuration:<br><br>





<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">listen_addresses = '<span class="gmail-s1" style="">*</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">port = 5432</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">socket_dir = '<span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">var</span><span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">run</span><span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">pgpool</span>'</font></span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span class="gmail-s3" style="">pid_file_name = '</span><span class="gmail-s1" style="">/</span>var<span class="gmail-s1" style="">/</span>run<span class="gmail-s1" style="">/</span>pgpool<span class="gmail-s1" style="">/</span>pgpool<span class="gmail-s1" style="">.</span>pid<span class="gmail-s3" style="">'</span></font></span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span class="gmail-s3" style="">pool_passwd = '</span><span class="gmail-s1" style="">/</span>etc<span class="gmail-s1" style="">/</span>pgpool<span class="gmail-s1" style="">/</span>pool_passwd<span class="gmail-s3" style="">'</span></font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">pcp_listen_addresses = '<span class="gmail-s1" style="">*</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">pcp_port = 9898</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">pcp_socket_dir = '<span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">var</span><span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">run</span><span class="gmail-s1" style="">/</span><span class="gmail-s2" style="">pgpool</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_hostname0 = '<span class="gmail-s4" style=""><b>primary</b></span><span class="gmail-s1" style="">.</span><span class="gmail-s2" style="">rds</span><span class="gmail-s1" style="">.</span><span class="gmail-s2" style="">url</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_port0 = 5432</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_weight0 = 1</font></span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span class="gmail-s3" style="">backend_flag0 = '</span>ALWAYS_PRIMARY<span class="gmail-s1" style="">|</span>DISALLOW_TO_FAILOVER<span class="gmail-s3" style="">'</span></font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_hostname1 = '<span class="gmail-s4" style=""><b>replica</b></span><span class="gmail-s1" style="">.</span><span class="gmail-s2" style="">rds</span><span class="gmail-s1" style="">.</span><span class="gmail-s2" style="">url</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_port1 = 5432</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_weight1 = 19</font></span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span class="gmail-s3" style="">backend_flag1 = '</span>DISALLOW_TO_FAILOVER<span class="gmail-s3" style="">'</span></font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">sr_check_period = 0</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">health_check_period = 0</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">enable_pool_hba = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">allow_clear_text_frontend_auth = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">backend_clustering_mode = '<span class="gmail-s2" style="">streaming_replication</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">num_init_children = 128</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">max_pool = 4</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">child_life_time = 300</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">child_max_connections = 0</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">connection_life_time = 0</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">client_idle_limit = 305</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">connection_cache = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">load_balance_mode = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">log_statement = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">log_connections = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">log_client_messages = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">log_per_node_statement = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">log_error_verbosity = terse</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">statement_level_load_balance = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">replication_mode = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">master_slave_mode = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">master_slave_sub_mode = stream</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">fail_over_on_backend_error = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">ssl = on</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">use_watchdog = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">memory_cache_enabled = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">enable_shared_relcache = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">primary_routing_query_pattern_list = '<span class="gmail-s1" style="">.*/\*.*</span><span class="gmail-s2" style="">NO_LOAD_BALANCE</span><span class="gmail-s1" style="">.*\*/.*</span>'</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">failover_on_backend_error = off</font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">authentication_timeout = 60<span class="gmail-Apple-converted-space"> </span></font></span></p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">client_idle_limit = 0</font></span></p><br>The pgpool version I'm using is 4.3.3 obtained from Alpine linux distribution, and it works great most of the time. However, sometimes I get the following error:<br><br>"child process with pid: xxx exits with status 4 by signal 4"<br><br>Signal 4 seems to be "SIGILL" and is mainly related to hardware issues. Yet this issue happens on all of the environments we are using and trying the configuration settings or pgpool versions did not help. I wonder if there is a solution to the issue since it causes the connections to be closed, and as a result, server-side errors happen.<br><br>Thanks a lot in advance for your guidance.</div>