<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi<div class=""><br class=""></div><div class="">I an very sorry for the late reply, but the issue has cleared itself when we increased the number of vCPU cores assigned to the pgPool node.</div><div class=""><br class=""></div><div class="">The data replication application my colleague is writing, while I manage the DB, appears to become stable at two vCPU and optimum performance at four vCPU, adding more nodes appears to make no difference to data loading on the clients, although we are still testing with </div><div class=""><br class=""></div><div class="">one pgPool node, 4vCPU and 4G memory</div><div class="">two Postgres nodes, 2 vCPU and 12G memory.</div><div class=""><br class=""></div><div class="">I wonder if the pgPool disconnected if the server was too busy? Anyway, all seems fine and as we scale up to 10-12 Postgres DBs we will keep an eye on pgPool.</div><div class=""><br class=""></div><div class="">Thanks for the offer of help,</div><div class=""><br class=""></div><div class="">Simon</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 25 Jan 2017, at 09:15, Muhammad Usama <<a href="mailto:m.usama@gmail.com" class="">m.usama@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi<div class=""><br class=""></div><div class="">Please share the <span id="gmail-a0768fe4-7e20-41e6-83db-bb0c275dfa19" class="gmail-GINGER_SOFTWARE_mark">pgpool.conf</span> and log files., Pgpool-II log should have the information why Pgpool is detaching the <span id="gmail-d1faa674-ad67-414f-bae4-0da80828b2e9" class="gmail-GINGER_SOFTWARE_mark">backend</span> node. </div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Best regards</div><div class="">Muhammad Usama</div><div class=""><br class=""></div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Wed, Jan 25, 2017 at 1:47 PM, Simon Windsor <span dir="ltr" class=""><<a href="mailto:simon.windsor@cornfield.me.uk" target="_blank" class="">simon.windsor@cornfield.me.uk</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi<br class="">
<br class="">
We are testing pgPool with two Postgres 9.5 nodes, and using pgPool to manage the replication of data to the two databases.<br class="">
<br class="">
Every few days, one of the nodes goes from status 2 to 3, until we re-atach the node. There doesn't appear to be anything that triggers this. Is this a known issue that we can handle automatically, if so how, or is there some logging I must enable to track the root casue?<br class="">
<br class="">
Thank you<br class="">
<br class="">
Simon<br class="">
<br class="">
-- <br class="">
Simon Windsor<br class="">
<br class="">
Eml: <a href="mailto:simon.windsor@cornfield.me.uk" target="_blank" class="">simon.windsor@cornfield.me.uk</a><br class="">
Tel: 01454 617689<br class="">
Mob: 0755 197 9733<br class="">
<br class="">
<br class="">
“There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that man's lawful prey.”<br class="">
<br class="">
______________________________<wbr class="">_________________<br class="">
pgpool-general mailing list<br class="">
<a href="mailto:pgpool-general@pgpool.net" target="_blank" class="">pgpool-general@pgpool.net</a><br class="">
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank" class="">http://www.pgpool.net/mailman/<wbr class="">listinfo/pgpool-general</a><br class="">
</blockquote></div><br class=""></div>
</div></blockquote></div><br class=""></div></body></html>