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

[Jayaraj]

I have already set that to sterr in the conf file

However, I am using PGPool 3.1.2

could this be a problem?

thanks

regards,
- jaya -


________________________________
 From: DonMartio <donmartio at larkos.de>
To: Tatsuo Ishii <ishii at postgresql.org> 
Cc: jraj90 at yahoo.com; pgpool-general at pgpool.net 
Sent: Friday, 18 May 2012, 15:11
Subject: Re: [pgpool-general: 461] Re: PgPool rejects connections
 
Well, this sounds familiar to me. Which version of pgpool-II are you using?
We got those CLOSE_WAIT's too during stress tests on our php framework.
They are gone since the last version 3.1.3. I assume it got something to 
do with a syslog issue.
May you try log_destination = 'stderr' in your pgpool.conf just to 
clarify if this is the case.


Am 16.05.2012 09:54, schrieb 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 -
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120518/f5c44969/attachment.html>