pgpool@ubuntu:~$ sudo pgpool -d -n start [sudo] password for pgpool: 2015-06-13 02:31:49 DEBUG: pid 3235: key: listen_addresses 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'localhost' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 5433 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: socket_dir 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/run/postgresql' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: pcp_port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 9898 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: pcp_socket_dir 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/run/postgresql' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: enable_pool_hba 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: pool_passwd 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'pool_passwd' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: authentication_timeout 2015-06-13 02:31:49 DEBUG: pid 3235: value: 60 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: ssl 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: num_init_children 2015-06-13 02:31:49 DEBUG: pid 3235: value: 32 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: max_pool 2015-06-13 02:31:49 DEBUG: pid 3235: value: 4 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: child_life_time 2015-06-13 02:31:49 DEBUG: pid 3235: value: 300 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: child_max_connections 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: connection_life_time 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: client_idle_limit 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_destination 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'stderr' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: print_timestamp 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_connections 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_hostname 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_statement 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_per_node_statement 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_standby_delay 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'none' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: syslog_facility 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'LOCAL0' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: syslog_ident 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'pgpool' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: debug_level 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: pid_file_name 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/run/pgpool.pid' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: logdir 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/log/postgresql' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: connection_cache 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: reset_query_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'ABORT; DISCARD ALL' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: ABORT 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: DISCARD ALL 2015-06-13 02:31:49 DEBUG: pid 3235: key: replication_mode 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: replicate_select 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: replicate_select: 0 2015-06-13 02:31:49 DEBUG: pid 3235: key: insert_lock 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: lobj_lock_table 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: replication_stop_on_mismatch 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: replication_stop_on_mismatch: 0 2015-06-13 02:31:49 DEBUG: pid 3235: key: failover_if_affected_tuples_mismatch 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: failover_if_affected_tuples_mismatch: 0 2015-06-13 02:31:49 DEBUG: pid 3235: key: load_balance_mode 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: ignore_leading_white_space 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: white_function_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: black_function_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'nextval,setval' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: nextval 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: setval 2015-06-13 02:31:49 DEBUG: pid 3235: add_to_patterns: regex pattern: ^nextval$ 2015-06-13 02:31:49 DEBUG: pid 3235: add_to_patterns: regex pattern: ^setval$ 2015-06-13 02:31:49 DEBUG: pid 3235: key: master_slave_mode 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: master_slave_sub_mode 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'slony' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: sr_check_period 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: sr_check_user 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'nobody' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: sr_check_password 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: delay_threshold 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: follow_master_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: parallel_mode 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: pgpool2_hostname 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_hostname 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 4532 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_dbname 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_schema 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_user 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: system_db_password 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_period 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_timeout 2015-06-13 02:31:49 DEBUG: pid 3235: value: 20 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_user 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'nobody' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_password 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_max_retries 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: health_check_retry_delay 2015-06-13 02:31:49 DEBUG: pid 3235: value: 1 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: failover_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: failback_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: fail_over_on_backend_error 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: search_primary_node_timeout 2015-06-13 02:31:49 DEBUG: pid 3235: value: 10 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: recovery_user 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'nobody' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: recovery_password 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: recovery_1st_stage_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: recovery_2nd_stage_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: recovery_timeout 2015-06-13 02:31:49 DEBUG: pid 3235: value: 90 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: client_idle_limit_in_recovery 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: use_watchdog 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: trusted_servers 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: ping_path 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/bin' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_hostname 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 9000 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_authkey 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: delegate_IP 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: ifconfig_path 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/sbin' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: if_up_cmd 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: if_down_cmd 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'ifconfig eth0:0 down' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: arping_path 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/usr/sbin # arping command path' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: arping_cmd 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'arping -U $_IP_$ -w 1' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: clear_memqcache_on_escalation 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_escalation_command 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_lifecheck_method 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'heartbeat' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_interval 2015-06-13 02:31:49 DEBUG: pid 3235: value: 10 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_heartbeat_port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 9694 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_heartbeat_keepalive 2015-06-13 02:31:49 DEBUG: pid 3235: value: 2 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_heartbeat_deadtime 2015-06-13 02:31:49 DEBUG: pid 3235: value: 30 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_life_point 2015-06-13 02:31:49 DEBUG: pid 3235: value: 3 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_lifecheck_query 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'SELECT 1' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_lifecheck_dbname 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'template1' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_lifecheck_user 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'nobody' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: wd_lifecheck_password 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: relcache_expire 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: relcache_size 2015-06-13 02:31:49 DEBUG: pid 3235: value: 256 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: check_temp_table 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: memory_cache_enabled 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_method 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'shmem' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_memcached_host 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'localhost' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_memcached_port 2015-06-13 02:31:49 DEBUG: pid 3235: value: 11211 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_total_size 2015-06-13 02:31:49 DEBUG: pid 3235: value: 67108864 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_max_num_cache 2015-06-13 02:31:49 DEBUG: pid 3235: value: 1000000 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_expire 2015-06-13 02:31:49 DEBUG: pid 3235: value: 0 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_auto_cache_invalidation 2015-06-13 02:31:49 DEBUG: pid 3235: value: on kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_maxcache 2015-06-13 02:31:49 DEBUG: pid 3235: value: 409600 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_cache_block_size 2015-06-13 02:31:49 DEBUG: pid 3235: value: 1048576 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: memqcache_oiddir 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/log/pgpool/oiddir' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: white_memqcache_table_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: black_memqcache_table_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: listen_backlog_multiplier 2015-06-13 02:31:49 DEBUG: pid 3235: value: 2 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: ssl_key 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: ssl_cert 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: ssl_ca_cert 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: ssl_ca_cert_dir 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_line_prefix 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_error_verbosity 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'DEFAULT' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: client_min_messages 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'notice' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: log_min_messages 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'warning' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: database_redirect_preference_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: app_name_redirect_preference_list 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: allow_sql_comments 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: connect_timeout 2015-06-13 02:31:49 DEBUG: pid 3235: value: 10000 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: check_unlogged_table 2015-06-13 02:31:49 DEBUG: pid 3235: value: off kind: 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_hostname0 2015-06-13 02:31:49 DEBUG: pid 3235: value: '172.16.16.101' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_port0 2015-06-13 02:31:49 DEBUG: pid 3235: value: 5342 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: port slot number 0 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_weight0 2015-06-13 02:31:49 DEBUG: pid 3235: value: 1 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: weight slot number 0 weight: 1.000000 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_data_directory0 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/lib/postgresql/9.3/main' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_flag0 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'ALLOW_TO_FAILOVER' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: ALLOW_TO_FAILOVER 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: allow_to_failover on 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: slot number 0 flag: 0000 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_hostname1 2015-06-13 02:31:49 DEBUG: pid 3235: value: '172.16.16.101' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_port1 2015-06-13 02:31:49 DEBUG: pid 3235: value: 5342 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: port slot number 1 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_weight1 2015-06-13 02:31:49 DEBUG: pid 3235: value: 1 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: weight slot number 1 weight: 1.000000 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_data_directory1 2015-06-13 02:31:49 DEBUG: pid 3235: value: '/var/lib/postgresql/9.3/main' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: backend_flag1 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'ALLOW_TO_FAILOVER' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: extract_string_tokens: token: ALLOW_TO_FAILOVER 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: allow_to_failover on 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: slot number 1 flag: 0000 2015-06-13 02:31:49 DEBUG: pid 3235: key: other_pgpool_hostname0 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: other_pgpool_port0 2015-06-13 02:31:49 DEBUG: pid 3235: value: kind: 7 2015-06-13 02:31:49 DEBUG: pid 3235: key: other_wd_port0 2015-06-13 02:31:49 DEBUG: pid 3235: value: kind: 7 2015-06-13 02:31:49 DEBUG: pid 3235: key: heartbeat_destination0 2015-06-13 02:31:49 DEBUG: pid 3235: value: 'host0_ip1' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: key: heartbeat_destination_port0 2015-06-13 02:31:49 DEBUG: pid 3235: value: 9694 kind: 2 2015-06-13 02:31:49 DEBUG: pid 3235: key: heartbeat_device0 2015-06-13 02:31:49 DEBUG: pid 3235: value: '' kind: 4 2015-06-13 02:31:49 DEBUG: pid 3235: num_backends: 2 total_weight: 2.000000 2015-06-13 02:31:49 DEBUG: pid 3235: backend 0 weight: 1073741823.500000 2015-06-13 02:31:49 DEBUG: pid 3235: backend 0 flag: 0000 2015-06-13 02:31:49 DEBUG: pid 3235: backend 1 weight: 1073741823.500000 2015-06-13 02:31:49 DEBUG: pid 3235: backend 1 flag: 0000 2015-06-13 02:31:49 DEBUG: pid 3235: pool_config: empty system_db_hostname, use PostgreSQL's default unix socket path (/var/run/postgresql) pgpool-II version 3.3.4 (tokakiboshi), A generic connection pool/replication/load balance server for PostgreSQL Usage: pgpool [ -c] [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] [ -n ] [ -D ] [ -d ] pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] [ -m SHUTDOWN-MODE ] stop pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] reload Common options: -a, --hba-file=HBA_CONFIG_FILE Sets the path to the pool_hba.conf configuration file (default: /etc/pgpool2/pool_hba.conf) -f, --config-file=CONFIG_FILE Sets the path to the pgpool.conf configuration file (default: /etc/pgpool2/pgpool.conf) -F, --pcp-file=PCP_CONFIG_FILE Sets the path to the pcp.conf configuration file (default: /etc/pgpool2/pcp.conf) -h, --help Prints this help Start options: -c, --clear Clears query cache (enable_query_cache must be on) -C, --clear-oidmaps Clears query cache oidmaps when memqcache_method is memcached (If shmem, discards whenever pgpool starts.) -n, --dont-detach Don't run in daemon mode, does not detach control tty -D, --discard-status Discard pgpool_status file and do not restore previous status -d, --debug Debug mode Stop options: -m, --mode=SHUTDOWN-MODE Can be "smart", "fast", or "immediate" Shutdown modes are: smart quit after all clients have disconnected fast quit directly, with proper shutdown immediate the same mode as fast 2015-06-13 02:31:49 DEBUG: pid 3235: shmem_exit(1)