<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>I have already set that to sterr in the conf file</span></div><div><span><br></span></div><div><span>However, I am using PGPool 3.1.2</span></div><div><span><br></span></div><div><span>could this be a problem?</span></div><div><span><br></span></div><div><span>thanks</span></div><div><span><br></span></div><div><span>regards,</span></div><div><span>- jaya -</span></div><div><br></div> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> DonMartio <donmartio@larkos.de><br> <b><span style="font-weight: bold;">To:</span></b> Tatsuo Ishii <ishii@postgresql.org> <br><b><span
style="font-weight: bold;">Cc:</span></b> jraj90@yahoo.com; pgpool-general@pgpool.net <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 18 May 2012, 15:11<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 461] Re: PgPool rejects connections<br> </font> </div> <br>Well, this sounds familiar to me. Which version of pgpool-II are you using?<br>We got those CLOSE_WAIT's too during stress tests on our php framework.<br>They are gone since the last version 3.1.3. I assume it got something to <br>do with a syslog issue.<br>May you try log_destination = 'stderr' in your pgpool.conf just to <br>clarify if this is the case.<br><br><br>Am 16.05.2012 09:54, schrieb Tatsuo Ishii:<br>> [Cced: to pgpool-general mailing list]<br>><br>> I'm not familiar with EC2. Anyone on this list can help him?<br>> --<br>> Tatsuo Ishii<br>> SRA OSS, Inc. Japan<br>> English: <a
href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>><br>>> Hi,<br>>><br>>> I have been using PgPool-II for my postgres DBs on the Amazon EC2 instances. However, I have been experiencing some issues. After a certain period of time, it no longer allows new connections from clients / application to the PgPool. It seems to get stuck in a TCP CLOSE_WAIT session. This basically accumulates to alot more which then disallows any further connections to the PgPool.<br>>><br>>> So at one point I had to temporarily set all connections directly to Postgres. The issue is resolved by restarting PgPool. Then after a certain period of time, it happens again, then another restart of Pgpool is required.<br>>><br>>> Can someone advise me how can I solve
this?<br>>><br>>> Thanks<br>>><br>>> Regards,<br>>> - Jaya -<br>> _______________________________________________<br>> pgpool-general mailing list<br>> <a ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br><br><br><br> </div> </div> </div></body></html>