hello, developers and anybody using pgpool. i have a something problem about 'streaming replication' and 'load balancing'. i don't know what mail address for to ask like this problem. then i send this asking mail to you. (if i mistake this doing, please teach me that i can ask mailling list.)
well, my question is this) <server spac> - my 1st postgresql server(os:ubuntu10.4, ip:192.168.3.160, postgresql version 9.1) run normal operations. (i checked that requested query success by use log) - my 2nd postgresql server(os:ubuntu10.4, ip:192.168.3.141, postgresql version 9.1) run normal operations too. (i checked it too.) - my pgpool server(ip:192.168.3.160 - with 1st postgresql server, pgpool version 3.1 - http://ftp2.jp.postgresql.org/pub/postgresql/projects/pgFoundry/pgpool/pgpool-II-3.1.tar.gz) run normal operations too. (i checked that requested query success by use log too.) <pgpool conf information> # cat pgpool.conf listen_addresses = '*' port = 9999 socket_dir = '/tmp' pcp_port = 9898 pcp_socket_dir = '/tmp' backend_hostname0 = '192.168.3.160' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/DbCenter_master/data' backend_flag0 = 'ALLOW_TO_FAILOVER' backend_hostname1 = '192.168.3.141' backend_port1 = 5432 backend_weight1 = 1000 backend_flag1 = 'ALLOW_TO_FAILOVER' enable_pool_hba = on authentication_timeout = 60 ssl = off num_init_children = 32 max_pool = 4 child_life_time = 300 child_max_connections = 0 connection_life_time = 0 client_idle_limit = 0 log_destination = 'syslog' print_timestamp = on log_connections = on log_hostname = on log_statement = on log_per_node_statement = on log_standby_delay = 'if_over_threshold' syslog_facility = 'LOCAL0' syslog_ident = 'pgpool' debug_level = 0 pid_file_name = '/var/run/pgpool/pgpool.pid' logdir = '/tmp' connection_cache = off reset_query_list = 'ABORT; DISCARD ALL' replication_mode = off replicate_select = off insert_lock = off lobj_lock_table = '' replication_stop_on_mismatch = off failover_if_affected_tuples_mismatch = 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 = 'repl_user' sr_check_password = 'password' delay_threshold = 10000000 follow_master_command = 'date > /DataCenter_nas/abc' parallel_mode = off enable_query_cache = off pgpool2_hostname = '' system_db_hostname = 'localhost' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'pgpool' system_db_password = '' health_check_period = 0 health_check_timeout = 20 health_check_user = 'nobody' health_check_password = '' failover_command = 'date > /DataCenter_nas/abc2' failback_command = 'date > /DataCenter_nas/abc3' fail_over_on_backend_error = on recovery_user = 'nobody' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 relcache_expire = 0 #-------------- the end of pgpool conf--------------- <i tried it> i send query request to pgpool, and 1st postgresql catch it always. it is a wrong working why i did set pgpools to 1:1000 about backend_weight0 and backend_weight1 values.(look my pgpool.conf file) i think that this case's good working is almost catch 2nd postgresql server. i don't know this working reason(about wrong pgpool's load balancing and after backend_hostname1 setting values). do you have to teach me about this problem or something idea? I hope your help. please help me. i waiting your mail. thanks.
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
