Are you sure that pgpool can connect to the second PG server? 2011/11/10 イジュヨン <elij...@gmail.com>: > 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 > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > >
-- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
