Hello, we are testing pgpool-II for data replication in our PostgreSQL-Cluster. pgpool is hanging during the combinations of select and update/insert statements within a transaction. We have reduced all to the following script:
---- begin sql --- SELECT 'DBD::Pg ping test'; BEGIN; select * from sometable; COMMIT select * from anothertable; --- end sql ---- pgpool is hanging after the commit-Statement. #---pgpool.conf -------------- listen_addresses = '*' port = 5432 pcp_port = 9898 socket_dir = '/var/run/postgresql' ... replication_mode = true replication_timeout = 5000 load_balance_mode = true replicate_select = false replication_stop_on_mismatch = true reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' print_timestamp = true connection_cache = true health_check_timeout = 20 health_check_period = 60 health_check_user = 'nobody' insert_lock = true ignore_leading_white_space = true ... parallel_mode = false enable_query_cache = false backend_hostname0 = 'dbfs2' backend_port0 = 5435 backend_weight0 = 1 backend_data_directory0 = '/pgpool/dbfs2' backend_hostname1 = 'dbfs3' backend_port1 = 5435 backend_weight1 = 1 backend_data_directory1 = '/pgpool/dbfs3' enable_pool_hba = false #--- end pgpool.conf After setting replicate_select = true all is working fine. ---- Best Regards / Mit freundlichen Grüßen Dr. R. Rohmfeld IT und Software Development e-mail: [EMAIL PROTECTED]
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
