[pgpool-general: 464] Re: PgPool rejects connections

[Jayaraj]

Do u think it could be because I am using EC2?

Is it possible I could have missed out some configuration in the PgPool config file which should close the connection?

Regards,
- Jaya -


________________________________
 From: Tatsuo Ishii <ishii at postgresql.org>
To: jraj90 at yahoo.com 
Cc: pgpool-general at pgpool.net 
Sent: Wednesday, 16 May 2012, 15:54
Subject: Re: PgPool rejects connections
 
[Cced: to pgpool-general mailing list]

I'm not familiar with EC2. Anyone on this list can help him?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
>     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.
> 
> 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.
> 
> Can someone advise me how can I solve this?
> 
> Thanks
> 
> Regards,
> - Jaya -  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120517/c4ceef2e/attachment.html>