<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1460120250911_4017" dir="ltr">Hi PGPOOL forum members,<br></div><div id="yui_3_16_0_ym19_1_1460120250911_4192" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1460120250911_4183" dir="ltr">I try to use PGPOOL-II 3.5.1 in "Replication Mode" with two backend servers of PostgreSQL 9.1.19. When I execute a modification SQL statement it is replicated to both servers. PGPOOL sends the replicated SQL first to one of the servers. When this SQL finishes and returns the result to PGPOOL, then PGPOOL sends the replicated SQL to the second server. </div><div id="yui_3_16_0_ym19_1_1460120250911_4428" dir="ltr">I presume that the replicated SQL statements should be send simultaneously to the backends in Replication Mode. Could not find any description (DOC, FAQ, Goo) on how should be sent the SQLs to the backends - either simultaneously or sequentially ?</div><div id="yui_3_16_0_ym19_1_1460120250911_4886" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1460120250911_4885" dir="ltr">My PGPOOL config is:</div><div id="yui_3_16_0_ym19_1_1460120250911_4907" dir="ltr">listen_addresses = '*'<br id="yui_3_16_0_ym19_1_1460120250911_4752">port = 5491<br id="yui_3_16_0_ym19_1_1460120250911_4753">socket_dir = '/var/run/postgresql'<br id="yui_3_16_0_ym19_1_1460120250911_4754">pcp_port = 9891<br id="yui_3_16_0_ym19_1_1460120250911_4755">pcp_socket_dir = '/var/run/postgresql'<br id="yui_3_16_0_ym19_1_1460120250911_4756">backend_hostname0 = 'ca-dbs05'<br id="yui_3_16_0_ym19_1_1460120250911_4757">backend_port0 = 10091<br id="yui_3_16_0_ym19_1_1460120250911_4758">backend_weight0 = 20<br id="yui_3_16_0_ym19_1_1460120250911_4759">backend_data_directory0 = '/opt/pgsql91/data/iiscpr'<br id="yui_3_16_0_ym19_1_1460120250911_4760">backend_flag0 = 'ALLOW_TO_FAILOVER'<br id="yui_3_16_0_ym19_1_1460120250911_4761">backend_hostname1 = 'ca-dbs04'<br id="yui_3_16_0_ym19_1_1460120250911_4762">backend_port1 = 10091<br id="yui_3_16_0_ym19_1_1460120250911_4763">backend_weight1 = 10<br id="yui_3_16_0_ym19_1_1460120250911_4764">backend_data_directory1 = '/opt/pgsql91/data/iiscpr'<br id="yui_3_16_0_ym19_1_1460120250911_4765">backend_flag1 = 'ALLOW_TO_FAILOVER'<br id="yui_3_16_0_ym19_1_1460120250911_4766">enable_pool_hba = on<br id="yui_3_16_0_ym19_1_1460120250911_4767">pool_passwd = 'pool_passwd'<br id="yui_3_16_0_ym19_1_1460120250911_4768">authentication_timeout = 60<br id="yui_3_16_0_ym19_1_1460120250911_4769">ssl = off<br id="yui_3_16_0_ym19_1_1460120250911_4770">num_init_children = 256<br id="yui_3_16_0_ym19_1_1460120250911_4771">max_pool = 8<br id="yui_3_16_0_ym19_1_1460120250911_4772">child_life_time = 300<br id="yui_3_16_0_ym19_1_1460120250911_4773">child_max_connections = 0<br id="yui_3_16_0_ym19_1_1460120250911_4774">connection_life_time = 0<br id="yui_3_16_0_ym19_1_1460120250911_4775">client_idle_limit = 0<br id="yui_3_16_0_ym19_1_1460120250911_4776">log_destination = 'stderr'<br id="yui_3_16_0_ym19_1_1460120250911_4777">print_timestamp = on<br id="yui_3_16_0_ym19_1_1460120250911_4778">log_connections = off<br id="yui_3_16_0_ym19_1_1460120250911_4779">log_hostname = off<br id="yui_3_16_0_ym19_1_1460120250911_4780">log_statement = off<br id="yui_3_16_0_ym19_1_1460120250911_4781">log_per_node_statement = on<br id="yui_3_16_0_ym19_1_1460120250911_4782">log_standby_delay = 'none'<br id="yui_3_16_0_ym19_1_1460120250911_4783">syslog_facility = 'LOCAL1'</div><div id="yui_3_16_0_ym19_1_1460120250911_4935" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1460120250911_4936" dir="ltr">Kind Regards</div><div id="yui_3_16_0_ym19_1_1460120250911_4937" dir="ltr">Lazar<br id="yui_3_16_0_ym19_1_1460120250911_4784">syslog_ident = 'pgpool'<br id="yui_3_16_0_ym19_1_1460120250911_4785">debug_level = 0<br id="yui_3_16_0_ym19_1_1460120250911_4786">pid_file_name = '/var/run/postgresql/pgpool.pid'<br id="yui_3_16_0_ym19_1_1460120250911_4787">logdir = '/var/log/postgresql'<br id="yui_3_16_0_ym19_1_1460120250911_4788">connection_cache = on<br id="yui_3_16_0_ym19_1_1460120250911_4789">reset_query_list = 'ABORT; DISCARD ALL'<br id="yui_3_16_0_ym19_1_1460120250911_4790">replication_mode = on<br id="yui_3_16_0_ym19_1_1460120250911_4791">replicate_select = off<br id="yui_3_16_0_ym19_1_1460120250911_4792">insert_lock = on<br id="yui_3_16_0_ym19_1_1460120250911_4793">lobj_lock_table = 'my_lock_table'<br id="yui_3_16_0_ym19_1_1460120250911_4794">replication_stop_on_mismatch = off<br id="yui_3_16_0_ym19_1_1460120250911_4795">failover_if_affected_tuples_mismatch = off<br id="yui_3_16_0_ym19_1_1460120250911_4796">load_balance_mode = on<br id="yui_3_16_0_ym19_1_1460120250911_4797">ignore_leading_white_space = on<br id="yui_3_16_0_ym19_1_1460120250911_4798">white_function_list = 'compare_versions_get_changed_imm_right,compare_versions_get_changed_imm,compare_versions_get_deleted_imm,compare_versions_get_new_imm,getfromekatte,getplaceforekatte,getprojectestate,getprojectversionname,getspobjectdesc,gettempcadregfull,gettempsurvpointreg,getunfinishedproject,ntables_ngetapptype,ntables_ngetboundarytype,ntables_ngetdenotationtype,ntables_ngetdeterminingtype,ntables_ngetfunctype,ntables_ngetisunmovable,ntables_ngetisupdate,ntables_ngetlaw,ntables_ngetlinesymboltype,ntables_ngetpointcenexist,ntables_ngetpointtype,ntables_ngetprecisiontype,ntables_ngetprojectstate,ntables_ngetprojlineboundarytype,ntables_ngetpropertytype,ntables_ngetpurposetype,ntables_ngetscheme_linetype,ntables_ngetsignaltype,ntables_ngetsource,ntables_ngetstabletype,ntables_ngetsubboundarytype,ntables_ngetsurveypointtype,ntables_ngettexttype,ntables_ngetusagetype,project_cadnumber_getresnumberfortask,,ntables_ngetfiletype,ntables_ngetprojecttype,sgetaddressinfo,adm_util_get_adm_offices,adm_util_get_adm_nomdesc,adm_util_get_user_sessions,adm_util_get_adm_userinfo,ntables_geo_get_npointclass,getdata_geo_get_cpoint,getdeletedcadnumbers,getdocdesc,sgetpersonsbyshortname,getdocumentbyprojectid,getekatte ,getekatte_desc,getekatte_in ,getofficebyekatte,getofficesbyzone,cad_validates_getvalidateforekatte,getprojectsandtasksiiscpr,getproject_xmlfile,getquarterforekatte,getreldocforservice,getrgonumberdesc,getstreetforekatte,getsubject,getsubjectdesc,xml_messages_xmlgetdocrights_kais,ntables_getntable,cad4_cad4_defs ,cad4_cad4_table,ntables_ngetapptype_short,ntables_ngetcadobjectactivitysearch,ntables_ngetdoctype,ntables_ngetekatte,ntables_ngetekattetype,ntables_ngethightcoordinatesystem,ntables_ngethightmethod,ntables_ngetidentstatus,ntables_ngetmunicipality,ntables_ngetofficepublisher,ntables_ngetplcoordinatesystem,ntables_ngetplmethod,cadfunctiondesc_getchangevalidatesbyservid,ntables_ngetpublisher,ntables_ngetquartertype,ntables_ngetreceivestatus,ntables_ngetregion,ntables_ngetrgoobjecttype,ntables_ngetrightchangeflag,cadobjects_record_getcadnumberengendered,cadobjects_record_getestatechangebyprojectid,cadobjects_record_getestateinfobycadnumanddate,ntables_ngetstreettitle,ntables_ngetstreettype,ntables_ngetsubtype,ntables_ngetsurveyortype,cad_serialize_getcadprojserialize,cad_serialize_geterrorinfo,project_cadnumber_getmaxnumber_scheme_app,cmcr_edit_sgetcadplace,cmcr_edit_sgetcadplacebyadmid,cmcr_edit_sgetcadquarter,cmcr_edit_sgetcadquarterbyadmid,cmcr_edit_sgetcadstreet,cmcr_edit_sgetcadstreetbyadmid,cmcr_edit_sgetnpublisher,cmcr_edit_sgetnpublisherbyadmid,sgetaddressinfo,getaddressdesc,sgetdocumentinfo,sgetpersonsbyname,cad_validates_getvalidatebasic,cad_validates_getvalidatebyservice,getinfoxml,getlayerstat,test_modul_info_get_bnd_info_by_ekatte,test_modul_info_getcadproj_comparenode_wkt,test_modul_info_getcadproj_compareedge_wkt,test_modul_info_getcadproj_comparepoly_wkt,test_modul_info_getcadproj_comparepoint_wkt,test_modul_info_getcadproj_compareline_wkt,test_modul_info_getcadproj_comparebnd_wkt'<br id="yui_3_16_0_ym19_1_1460120250911_4799">black_function_list = ''<br id="yui_3_16_0_ym19_1_1460120250911_4800">master_slave_mode = off<br id="yui_3_16_0_ym19_1_1460120250911_4801">master_slave_sub_mode = 'slony'<br id="yui_3_16_0_ym19_1_1460120250911_4802">sr_check_period = 0<br id="yui_3_16_0_ym19_1_1460120250911_4803">sr_check_user = 'nobody'<br id="yui_3_16_0_ym19_1_1460120250911_4804">sr_check_password = ''<br id="yui_3_16_0_ym19_1_1460120250911_4805">delay_threshold = 0<br id="yui_3_16_0_ym19_1_1460120250911_4806">follow_master_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4807">parallel_mode = off<br id="yui_3_16_0_ym19_1_1460120250911_4808">pgpool2_hostname = ''<br id="yui_3_16_0_ym19_1_1460120250911_4809">system_db_hostname = 'localhost'<br id="yui_3_16_0_ym19_1_1460120250911_4810">system_db_port = 5432<br id="yui_3_16_0_ym19_1_1460120250911_4811">system_db_dbname = 'pgpool'<br id="yui_3_16_0_ym19_1_1460120250911_4812">system_db_schema = 'pgpool_catalog'<br id="yui_3_16_0_ym19_1_1460120250911_4813">system_db_user = 'pgpool'<br id="yui_3_16_0_ym19_1_1460120250911_4814">system_db_password = ''<br id="yui_3_16_0_ym19_1_1460120250911_4815">health_check_period = 0<br id="yui_3_16_0_ym19_1_1460120250911_4816">health_check_timeout = 20<br id="yui_3_16_0_ym19_1_1460120250911_4817">health_check_user = 'nobody'<br id="yui_3_16_0_ym19_1_1460120250911_4818">health_check_password = ''<br id="yui_3_16_0_ym19_1_1460120250911_4819">health_check_max_retries = 0<br id="yui_3_16_0_ym19_1_1460120250911_4820">health_check_retry_delay = 1<br id="yui_3_16_0_ym19_1_1460120250911_4821">failover_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4822">failback_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4823">fail_over_on_backend_error = on<br id="yui_3_16_0_ym19_1_1460120250911_4824">search_primary_node_timeout = 10<br id="yui_3_16_0_ym19_1_1460120250911_4825">recovery_user = 'nobody'<br id="yui_3_16_0_ym19_1_1460120250911_4826">recovery_password = ''<br id="yui_3_16_0_ym19_1_1460120250911_4827">recovery_1st_stage_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4828">recovery_2nd_stage_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4829">recovery_timeout = 90<br id="yui_3_16_0_ym19_1_1460120250911_4830">client_idle_limit_in_recovery = 0<br id="yui_3_16_0_ym19_1_1460120250911_4831">use_watchdog = on<br id="yui_3_16_0_ym19_1_1460120250911_4832">trusted_servers = 'ca-dbs04'<br id="yui_3_16_0_ym19_1_1460120250911_4833">ping_path = '/bin'<br id="yui_3_16_0_ym19_1_1460120250911_4834">wd_hostname = 'ca-dbs05'<br id="yui_3_16_0_ym19_1_1460120250911_4835">wd_port = 9091<br id="yui_3_16_0_ym19_1_1460120250911_4836">wd_authkey = 'pg@agkk1'<br id="yui_3_16_0_ym19_1_1460120250911_4837">delegate_IP = '192.168.0.219'<br id="yui_3_16_0_ym19_1_1460120250911_4838">ifconfig_path = '/opt/pgsql91/bin/'<br id="yui_3_16_0_ym19_1_1460120250911_4839">if_up_cmd = 'ifconfig bond0:vip inet $_IP_$ netmask 255.255.255.0'<br id="yui_3_16_0_ym19_1_1460120250911_4840">if_down_cmd = 'ifconfig bond0:vip down'<br id="yui_3_16_0_ym19_1_1460120250911_4841">arping_path = '/opt/pgsql91/bin/'<br id="yui_3_16_0_ym19_1_1460120250911_4842">arping_cmd = 'arping -U $_IP_$ -w 1 -c 50'<br id="yui_3_16_0_ym19_1_1460120250911_4843">clear_memqcache_on_escalation = on<br id="yui_3_16_0_ym19_1_1460120250911_4844">wd_escalation_command = ''<br id="yui_3_16_0_ym19_1_1460120250911_4845">wd_lifecheck_method = 'heartbeat'<br id="yui_3_16_0_ym19_1_1460120250911_4846">wd_interval = 10<br id="yui_3_16_0_ym19_1_1460120250911_4847">wd_heartbeat_port = 9691<br id="yui_3_16_0_ym19_1_1460120250911_4848">wd_heartbeat_keepalive = 2<br id="yui_3_16_0_ym19_1_1460120250911_4849">wd_heartbeat_deadtime = 30<br id="yui_3_16_0_ym19_1_1460120250911_4850">heartbeat_destination0 = 'ca-dbs04'<br id="yui_3_16_0_ym19_1_1460120250911_4851">heartbeat_destination_port0 = 9691 <br id="yui_3_16_0_ym19_1_1460120250911_4852">heartbeat_device0 = ''<br id="yui_3_16_0_ym19_1_1460120250911_4853">wd_life_point = 3<br id="yui_3_16_0_ym19_1_1460120250911_4854">wd_lifecheck_query = 'SELECT 1'<br id="yui_3_16_0_ym19_1_1460120250911_4855">wd_lifecheck_dbname = 'template1'<br id="yui_3_16_0_ym19_1_1460120250911_4856">wd_lifecheck_user = 'nobody'<br id="yui_3_16_0_ym19_1_1460120250911_4857">wd_lifecheck_password = ''<br id="yui_3_16_0_ym19_1_1460120250911_4858">other_pgpool_hostname0 = 'ca-dbs04'<br id="yui_3_16_0_ym19_1_1460120250911_4859">other_pgpool_port0 = 5491<br id="yui_3_16_0_ym19_1_1460120250911_4860">other_wd_port0 = 9091<br id="yui_3_16_0_ym19_1_1460120250911_4861">relcache_expire = 0<br id="yui_3_16_0_ym19_1_1460120250911_4862">relcache_size = 256<br id="yui_3_16_0_ym19_1_1460120250911_4863">check_temp_table = on<br id="yui_3_16_0_ym19_1_1460120250911_4864">memory_cache_enabled = off<br id="yui_3_16_0_ym19_1_1460120250911_4865">memqcache_method = 'shmem'<br id="yui_3_16_0_ym19_1_1460120250911_4866">memqcache_memcached_host = 'localhost'<br id="yui_3_16_0_ym19_1_1460120250911_4867">memqcache_memcached_port = 11211<br id="yui_3_16_0_ym19_1_1460120250911_4868">memqcache_total_size = 67108864<br id="yui_3_16_0_ym19_1_1460120250911_4869">memqcache_max_num_cache = 1000000<br id="yui_3_16_0_ym19_1_1460120250911_4870">memqcache_expire = 0<br id="yui_3_16_0_ym19_1_1460120250911_4871">memqcache_auto_cache_invalidation = on<br id="yui_3_16_0_ym19_1_1460120250911_4872">memqcache_maxcache = 409600<br id="yui_3_16_0_ym19_1_1460120250911_4873">memqcache_cache_block_size = 1048576<br id="yui_3_16_0_ym19_1_1460120250911_4874">memqcache_oiddir = '/var/log/pgpool/oiddir'<br id="yui_3_16_0_ym19_1_1460120250911_4875">white_memqcache_table_list = ''<br id="yui_3_16_0_ym19_1_1460120250911_4876">black_memqcache_table_list = ''<br id="yui_3_16_0_ym19_1_1460120250911_4877"></div><div dir="ltr"><br></div></div></body></html>