[pgpool-general: 497] PgPool Config

David Kerr dmk at mr-paradox.net
Fri May 25 01:29:10 JST 2012


Howdy,

I'm trying to use pgpool to facilitate failover and also to load balance my Postgres nodes.

I don't want to use the pooling if possible.

I'm seeing connections hang when i try psql -h <bla>

On my pgpool system i have two types of PgPool processes:

postgres 15949 15894  0 16:07 ?        00:00:00 pgpool: wait for connection request 
and 
postgres 15950 15894  0 16:07 ?        00:00:00 pgpool: accept connection

What's the "accept connection"?

I've attached some relevent paramters that i've changed. (if it's not here it's default)

listen_addresses = '*'
port = 15432
backend_hostname0 = 'masterpg'
backend_port0 = 15432
backend_weight0 = 0
backend_data_directory0 = '/db/9.1/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_hostname1 = 'standbypg'
backend_port1 = 25432
backend_weight1 = 0
backend_data_directory1 = '/db2/9.1/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
enable_pool_hba = on
num_init_children = 100
max_pool = 4
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
connection_cache = off
reset_query_list = 'ABORT; DISCARD ALL'
replication_mode = off
load_balance_mode = on
ignore_leading_white_space = on
white_function_list = ''
black_function_list = 'currval,lastval,nextval,setval'
master_slave_mode = on
master_slave_sub_mode = 'stream'
sr_check_period = 10
sr_check_user = 'pgpool'
sr_check_password = ''
delay_threshold = 10000000
parallel_mode = off
health_check_period = 10
health_check_timeout = 20
health_check_user = 'pgpool'
health_check_password = ''
failover_command = '/var/lib/pgsql/bin/failover_command.ksh %H %D %d %P'
failback_command = ''
fail_over_on_backend_error = on


More information about the pgpool-general mailing list