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

[Tatsuo Ishii]

[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 -