[pgpool-general: 503] Re: PgPool Config

[Tatsuo Ishii]

No immediate idea for now. I will investigate this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

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