[pgpool-general: 501] Re: PgPool Config

[Tatsuo Ishii]

If you change to:

connection_cache = on

psql does not hang?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general