<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Do u think it could be because I am using EC2?</span></div><div><span><br></span></div><div><span>Is it possible I could have missed out some configuration in the PgPool config file which should close the connection?</span></div><div><br></div><div>Regards,</div><div>- Jaya -</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> Tatsuo Ishii <ishii@postgresql.org><br> <b><span style="font-weight: bold;">To:</span></b> jraj90@yahoo.com <br><b><span style="font-weight: bold;">Cc:</span></b> pgpool-general@pgpool.net <br> <b><span style="font-weight:
bold;">Sent:</span></b> Wednesday, 16 May 2012, 15:54<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: PgPool rejects connections<br> </font> </div> <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><br> </div> </div> </div></body></html>