[pgpool-general: 1338] pgpool - attach node - double number of	connection
    Witold Duranek 
    witold.duranek at esky.pl
       
    Wed Jan 23 21:48:14 JST 2013
    
    
  
Hello,
 
I'm using pgpool:
pgpool-II version 3.1.1 (hatsuiboshi)
 
in mode:
 
master_slave_mode = on
master_slave_sub_mode = 'stream'
 
when i detach slave node from pgpool and attach it again the numer of
connection to postgresql on master doubles. Half of them is set earlier and
not use any more. 
 
tcp        0      0 127.0.0.1:44293         127.0.0.1:5433
ESTABLISHED 26720/pgpool: wait
tcp        0      0 127.0.0.1:44662         127.0.0.1:5433
ESTABLISHED 26720/pgpool: wait
 
in log I have got
 
Do not restart children because we are failbacking node id 0
 
num_init_children = 25
max_pool = 1
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
 
when i change child_max_connections to 200, after 200 connection the new
child occupy only one connection.
 
Is it normal situation ? 
 
Best regards 
witalis 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20130123/8b5243fd/attachment.htm>
    
    
More information about the pgpool-general
mailing list