listen_addresses = '*' port = 5432 socket_dir = '/var/run/postgresql' pcp_port = 9898 pcp_socket_dir = '/var/run/postgresql' backend_hostname0 = '' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/data/postgresql' backend_flag0 = 'ALLOW_TO_FAILOVER' backend_hostname1 = '' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/data/postgresql' backend_flag1 = 'ALLOW_TO_FAILOVER' enable_pool_hba = on pool_passwd = 'pool_passwd' authentication_timeout = 60 ssl = on ssl_key = '/etc/pgpool2/ssl/server.key' ssl_cert = '/etc/pgpool2/ssl/server.crt' num_init_children = 256 max_pool = 4 child_life_time = 300 child_max_connections = 0 connection_life_time = 0 client_idle_limit = 0 log_destination = 'syslog' print_timestamp = on log_connections = off log_hostname = off log_statement = on log_per_node_statement = on log_standby_delay = 'none' syslog_facility = 'LOCAL0' syslog_ident = 'pgpool' debug_level = 0 pid_file_name = '/var/run/postgresql/pgpool.pid' logdir = '/var/log/postgresql' connection_cache = on reset_query_list = 'ABORT; DISCARD ALL' replication_mode = on replicate_select = off insert_lock = on lobj_lock_table = '' replication_stop_on_mismatch = on failover_if_affected_tuples_mismatch = on load_balance_mode = on ignore_leading_white_space = on white_function_list = '' black_function_list = 'nextval,setval' master_slave_mode = off master_slave_sub_mode = 'slony' sr_check_period = 0 sr_check_user = 'nobody' sr_check_password = '' delay_threshold = 0 follow_master_command = '' parallel_mode = off 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 = '' health_check_period = 0 health_check_timeout = 20 health_check_user = 'pgpool' health_check_password = '' health_check_max_retries = 0 health_check_retry_delay = 1 failover_command = '' failback_command = '' fail_over_on_backend_error = on recovery_user = 'postgres' recovery_password = '' recovery_1st_stage_command = 'stage_one.sh' recovery_2nd_stage_command = 'stage_two.sh' recovery_timeout = 10 client_idle_limit_in_recovery = 1 use_watchdog = on trusted_servers = '' delegate_IP = '' wd_hostname = '' wd_port = 9000 wd_interval = 10 ping_path = '/bin' ifconfig_path = '/usr/local/bin' if_up_cmd = 'pgp_ifconfig eth1:db $_IP_$ 255.255.255.255 up' if_down_cmd = 'pgp_ifconfig eth1:db $_IP_$ 255.255.255.255 down' arping_path = '/usr/bin' # arping command path arping_cmd = 'sudo /usr/sbin/arpsend -U -i $_IP_$ -c1 eth1:db' wd_life_point = 3 wd_lifecheck_query = 'SELECT 1' other_pgpool_hostname0 = '' other_pgpool_port0 = 5432 other_wd_port0 = 9000 relcache_expire = 0 relcache_size = 256 check_temp_table = on memory_cache_enabled = off memqcache_method = 'shmem' memqcache_memcached_host = 'localhost' memqcache_memcached_port = 11211 memqcache_total_size = 67108864 memqcache_max_num_cache = 1000000 memqcache_expire = 0 memqcache_auto_cache_invalidation = on memqcache_maxcache = 409600 memqcache_cache_block_size = 1048576 memqcache_oiddir = '/var/log/pgpool/oiddir' white_memqcache_table_list = '' black_memqcache_table_list = ''