I setup pgpool-3.0.4 (config attached) in our staging environment. In staging, we have 5 servers which make a total of 35 connections (multiple rails thin webservers on each).
In pgpool, I see 35 connections from the 5 servers. In the backend db, I expected to see less than 35, but I don't. I see all 35 connections. Is this because the thin server makes a persistent connection? If so, then pgpool won't help me in terms of pooling connections? johnny /etc/pgpool-II-90/pgpool.conf: listen_addresses = '*' port = 9999 pcp_port = 9898 socket_dir = '/tmp' pcp_socket_dir = '/tmp' backend_socket_dir = '/var/run/pgpool-II-90' pcp_timeout = 10 num_init_children = 40 max_pool = 6 child_life_time = 300 connection_life_time = 0 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 logdir = '/var/log/pgpool-II' pid_file_name = '/var/run/pgpool-II-90/pgpool.pid' replication_mode = false load_balance_mode = false replication_stop_on_mismatch = false failover_if_affected_tuples_mismatch = false replicate_select = false reset_query_list = 'ABORT; DISCARD ALL' white_function_list = '' black_function_list = 'nextval,setval' print_timestamp = true master_slave_mode = false master_slave_sub_mode = 'slony' delay_threshold = 0 log_standby_delay = 'none' connection_cache = true health_check_timeout = 20 health_check_period = 0 health_check_user = 'nobody' failover_command = '' failback_command = '' fail_over_on_backend_error = true insert_lock = true 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 = '' system_db_hostname = 'localhost' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'pgpool' system_db_password = '' backend_hostname0 = 'db-staging9' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/var/db/postgresql/data' enable_pool_hba = false recovery_user = 'nobody' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 lobj_lock_table = '' ssl = false debug_level = 1 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
