<div dir="ltr"><span id="result_box" class="" lang="en"><span class="">good morning</span><span>,</span> <span class="">I have</span> <span class="">a query that</span> <span class="">I would like</span> <span class="">them</span> <span class="">because</span> <span class="">I find a</span> <span class="">pretty big</span> <span class="">question</span><span>,</span> <span class="">I have</span> <span class="">installed</span> <span class="">postgresql</span> <span class="">9.2</span> <span class="">+</span> <span class="">pgpool</span><span class="">-</span><span>II</span> <span class="">3.2.4</span> <span class="">on a</span> <span class="">Redhat</span> <span class="">system</span> <span class="">6</span> <span class="">64</span> <span class="">bits</span> <span class="">and</span> <span class="">heartbeat</span><span>.</span> <span class="">my question is</span><span class="">, what</span> <span class="">should</span> <span class="">be the operating system</span> <span class="">and</span> <span class="">database</span> <span class="">version</span> <span class="">for the</span> <span class="">pgpool</span><span class="">-</span><span>II</span> <span class="">works</span> <span class="">properly</span> <span class="">optimized</span><span class="">,</span> <span class="">the</span> <span class="">pgpool</span><span class="">-</span><span>II</span> <span class="">is certified</span> <span class="">to work in a</span> <span class="">specific environment</span><span>.</span> <span class="">I&#39;m</span> <span class="">currently</span> <span class="">testing</span> <span class="">in the environment</span> <span class="">mentioned</span> <span class="">above,</span> <span class="">but I&#39;m</span> <span class="">encountering</span> <span class="">some problems</span><span>, it is</span> <span class="">an error that</span> <span class="">is</span> <span class="">repeated every</span> <span class="">4 to 5 hours.<br>
pool_read: read failed (Connection reset by peer)<br>May 16 16:34:56 pg01 pgpool[8196]: degenerate_backend_set: 1 fail over request from pid 8196<br>May 16 16:34:56 pg01 pgpool[8196]: pool_flush_it: write failed to backend (1). reason: Broken pipe offset: 0 wlen: 5<br>
May 16 16:34:56 pg01 pgpool[12089]: starting degeneration. shutdown host 192.169.103.22(5432)<br>May 16 16:34:56 pg01 pgpool[12089]: Restart all children<br>May 16 16:34:56 pg01 pgpool[12089]: execute command: pgpool-failover<br>
May 16 16:34:56 pg01 pgpool[12089]: failover: set new primary node: -1<br>May 16 16:34:56 pg01 pgpool[12089]: failover: set new master node: 0<br>May 16 16:34:56 pg01 pgpool[12089]: failover done. shutdown host 192.169.103.22(5432)<br>
May 16 16:34:56 pg01 pgpool[5422]: worker process received restart request<br>May 16 16:34:57 pg01 pgpool[5420]: pcp child process received restart request<br>May 16 16:34:57 pg01 pgpool[12089]: PCP child 5420 exits with status 256 in failover()<br>
May 16 16:34:57 pg01 pgpool[12089]: fork a new PCP child pid 12124 in failover()<br>May 16 16:34:57 pg01 pgpool[12089]: worker child 5422 exits with status 256<br>May 16 16:34:57 pg01 pgpool[12089]: fork a new worker child pid 12125<br>
<br></span></span><span id="result_box" class="" lang="en">  <span class="">has become</span> <span class="">a constant error</span><span>,</span> <span class="">and we have verified</span> <span class="">and</span> <span class="">you got</span> <span class="">no</span> <span class="">network errors</span> <span class="">or something.</span> <span class="">if anyone can help</span> <span class="">I</span> <span class="">would be very grateful</span></span><br>
</div>