Hello! I using pgpool2 v3.1 and two PostgreSQL 9.0.4 (Master/Slave with stream replication)
Client send query "BEGIN;LOCK TABLE _1SCONNECT IN EXCLUSIVE MODE;" and pgpool sends this query master and slave, after slave print to log "cannot execute LOCK TABLE during recovery". Why pgpool sends this query to slave? How to change this behavior? My config: ----------- listen_addresses = '*' port = 5432 pcp_port = 9898 pcp_timeout = 10 num_init_children = 32 max_pool = 4 child_life_time = 300 connection_life_time = 0 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 debug_level = 0 pid_file_name = '/var/run/pgpool/pgpool.pid' replication_mode = false load_balance_mode = true replication_stop_on_mismatch = false replicate_select = true reset_query_list = 'ABORT; DISCARD ALL' print_timestamp = false master_slave_mode = true master_slave_sub_mode = 'stream' delay_threshold = 0 sr_check_period = 0 sr_check_user = postgres sr_check_password = postgres log_standby_delay = none connection_cache = true health_check_timeout = 20 health_check_period = 5 health_check_user = 'postgres' health_check_password = 'postgres' failover_command = '/usr/local/bin/failover_stream.sh %d % H /var/lib/pgsql/data/trigger' failback_command = '' fail_over_on_backend_error = true insert_lock = false ignore_leading_white_space = true log_statement = false log_per_node_statement = false log_connections = false log_hostname = false parallel_mode = false enable_query_cache = false pgpool2_hostname = 'T1' backend_hostname2 = 'T2' backend_port2 = 5432 backend_weight2 = 1 backend_data_directory2 = '/var/lib/pgsql/data' backend_hostname3 = 'T3' backend_port3 = 5432 backend_weight3 = 1 backend_data_directory3 = '/var/lib/pgsql/data' enable_pool_hba = false recovery_user = 'postgres' recovery_password = '' recovery_1st_stage_command = 'basebackup.sh' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 lobj_lock_table = '' ----------- _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
