[pgpool-general: 502] Re: PgPool Config

[David Kerr]

Yes! Any idea why?

Thanks

Dave


On 5/24/2012 5:14 PM, Tatsuo Ishii wrote:
> 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
>