<div dir="ltr"><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-09-08 6:47 GMT-03:00 Anselme Rabouan <span dir="ltr"><<a href="mailto:anselme.rabouan@lifecycle-software.com" target="_blank">anselme.rabouan@lifecycle-software.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)">Hi,</div><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)"><br></div><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)">We have a test platform where ours applications connect to pgpool2 v3.3.3 for few months ago.</div><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)">Sometimes, pgpool hangs and I don't why as I don't know how to investigate logs.</div><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)">Could you please give a way to track errors from log file ?</div></div></blockquote><div><br><br>There are many ways to find errors on a log file. The usual is greeping "ERROR" from the command<br>line. <br><br></div><div>How did you start the pgpool service? How your configuration file looks like?<br><br></div><div>3.3.4 is available now, so you can consider to upgrade soon.<br></div><div><br> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)">I guess this is due to the number of connection opened has been reached but not sure.</div><div style="font-family:arial,sans-serif;font-size:13px;color:rgb(136,136,136)"><br></div></div></blockquote><div><br></div></div>If that is the case, you should being receiving an error from the psql or the client that you're using<br>to connect with.<br clear="all"></div><div class="gmail_extra"><br>-- <br><div dir="ltr">--<br>Emanuel Calvo <a href="http://www.2ndQuadrant.com/" target="_blank">http://www.2ndQuadrant.com/</a><br>PostgreSQL Development, 24x7 Support, Training & Services<br></div>
</div></div>