[pgpool-general: 2432] Re: pgpool connections: FATAL: sorry, too many clients already

[Sergey Arlashin]

On Jan 16, 2014, at 4:25 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

>> Hi!
>> 
>> It seems I ran into another problem.
>> 
>> I have pgpool 3.3.1 with 2 postgresql 9.3 backends with streaming replication. I'm trying to set the correct number of allowed connections.
>> 
>> These are settings from postgresl.conf on both postgresql backends:
>> 
>> max_connections               = 30
>> superuser_reserved_connections = 3
>> 
>> 
>> These are settings from pgpool.conf:
>> 
>> num_init_children             = 25
>> max_pool                      = 2
>> 
>> I set these values according to the following formula:
>> 
>> max_pool*num_init_children <= (max_connections - superuser_reserved_connections) 
>> 
>> 2 * 25 <= ( 30 - 3 )*2
> 
> Where does the caliculation come from?
> Isn't that should be:
> 
> 2 * 25 <= ( 30 - 3 )
> 
> and it is going to be false.

It seems I misunderstood this formula :) 

I have 2 backends. Each can handle 27 connections. So I want pgpool to be able to handle 27*2 connections. 


If I use 

13 * 2 <= (30 -3 ) 

then the total number of connections won't exceed 26. Is that correct? 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140116/6fcdfa90/attachment.htm>