Hi, I am using Pgpool for a while and we are happy to use it for few of our production servers. Suddenly I had this issue..
We are using pgpool for replication with Online Recovery, Its working fine for 1-2 Hours and then its dropping secondary back-end host[Even postgres on it running] from pool, some times I can recover it using recovery scripts, but some times I need to restart[ kill -9] pgpool to recover it. I couldnt find any useful information in both pgpool and postgres logs. As per my knowledge, pgpool drops nodes only if it fails in health-check. Am I correct? or does pgpool take anything else My pgpool.conf file has these values listen_addresses = '*' port = 5432 pcp_port = 9898 socket_dir = '/tmp' pcp_socket_dir = '/tmp' backend_socket_dir = '/tmp' pcp_timeout = 10 num_init_children = 250 max_pool = 1 child_life_time = 120 connection_life_time = 300 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 logdir = '/data/pgsql/pgpool/logs' pid_file_name = '/data/pgsql/pgpool/logs/pgpool.pid' replication_mode = true load_balance_mode = false replication_stop_on_mismatch = false replicate_select = false reset_query_list = 'ABORT; DISCARD ALL' print_timestamp = true master_slave_mode = false connection_cache = true health_check_timeout = 90 health_check_period = 30 health_check_user = 'postgres' insert_lock = false ignore_leading_white_space = true log_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 = 'x.x.x.x' backend_port0 = 5433 backend_weight0 = 1 backend_data_directory0 = '/data/pgsql/pgsql3' backend_hostname1 = 'x.x.x.x' backend_port1 = 5433 backend_weight1 = 0 backend_data_directory1 = '/data/pgsql/pgsql3' enable_pool_hba = false recovery_user = 'postgres' recovery_password = 'xxxxx' recovery_1st_stage_command = 'copy_base_backup' recovery_2nd_stage_command = 'pgpool_recovery_pitr' recovery_timeout = 150 client_idle_limit_in_recovery = 120 Any Help / Suggestions please? Thanks & Regards, Sridhar Reddapani,
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
