[Pgpool-general] pgpool hangs up

Max Zorloff zorloff at gmail.com
Mon Aug 27 13:13:30 UTC 2007


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

> Could you show us the config file?

I tried also to connect with "psql -h localhost -p 10000" during this  
time. psql just hangs waiting.
After the restart everything is fine for some time.

The config is:
listen_addresses = 'localhost'
port = 10000
socket_dir = '/tmp'
backend_host_name = ''
backend_port = 5432
backend_socket_dir = '/tmp'
secondary_backend_host_name = ''
secondary_backend_port = 0
num_init_children = 3
max_pool = 4
child_life_time = 0
connection_life_time = 0
child_max_connections = 0
logdir = '/tmp'
replication_mode = false
replication_strict = true
replication_timeout = 5000
load_balance_mode = false
weight_master = 0.5
weight_secondary = 0.5
replication_stop_on_mismatch = false
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = false
connection_cache = true
health_check_timeout = 20
health_check_period = 0
health_check_user = 'nobody'
insert_lock = false
ignore_leading_white_space = false
log_statement = false


More information about the Pgpool-general mailing list