[Pgpool-general] pgpool hangs up

[Max Zorloff]

On Sun, 26 Aug 2007 20:32:38 +0400, HinYinLam <hinyinanobii at gmail.com>  
wrote:

> Hi,
> Yes, I have this issues also, what you can do is to increase your
> maximum number of children.
> for example you have max connection of 400 in postgres, then I think
> 350-400 in maxChild will be ok.
> PGPool claims that the connections will be stored in Kernel, but I found
> out the connections is actually do nothings...
> Don't know if it is a kernel problem or not...

What's the point in increasing the number of connections? In that case I  
might
as well simply stop using pgpool.

BTW, I think I found the solution - restart pgpool every 30 minutes by  
cron job.
I'll see if that will be enough.


> Regards,
> Hin
>> Hi.
>>
>> I've installed pgpool on the way between apache and postgres. The  
>> trouble
>> is that after 2-3 hours of work it simply stops receiving connections  
>> from
>> apache and just runs doing nothing. I see nothing in the log and just  
>> have
>> to restart.
>> I tried pgpool 3.1.1 and pgpool 3.4, it's the same. Does anyone know  
>> what
>> is the problem?
>>
>> Thank you.
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general