yes, i am sure. I tried it)
I tried a test how to change backend_hostname0 and backend_hostname1. (like as .. backend_hostname0='192.168.3.141' backend_weight0 = 1 # but not changed 'backend_weight0' backend_hostname1='192.168.3.160' backend_weight1 = 1000 # not changed 'backend_weight1' too. ... ) then pgpool has always connected backend_hostname0(192.168.3.141). i think that this mean is 'can not reading pgpool load balancing' or 'can not reading PG server after backend_hostname0'. what do you have a idea about something please? 2011/11/11 Martín Marqués <[email protected]> > Are you sure that pgpool can connect to the second PG server? > > 2011/11/10 イジュヨン <[email protected]>: > > 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 > > > > > > > > -- > Martín Marqués > select 'martin.marques' || '@' || 'gmail.com' > DBA, Programador, Administrador >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
