#
# required_config generated by pgpool_conf resource
#
port = 9999
pcp_port = 9898

backend_hostname0 = 'dld220822093114'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/edodata/pgsql/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_application_name0 = 'dld220822093114'
backend_hostname1 = 'dld220822093119'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/edodata/pgsql/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_application_name1 = 'dld220822093119'

use_watchdog = on
wd_lifecheck_method = 'heartbeat'


hostname0 = 'dld220822093125'
wd_port0 = 9000
pgpool_port00 = 9999

heartbeat_hostname0 = 'dld220822093125'
heartbeat_port0 = 9694
heartbeat_device0 = ''

hostname1 = 'dld220822093130'
wd_port1 = 9000
pgpool_port01 = 9999

heartbeat_hostname1 = 'dld220822093130'
heartbeat_port1 = 9694
heartbeat_device1 = ''


# additional_config generated by pgpool_conf resource
#
backend_clustering_mode = 'streaming_replication'
follow_primary_command = '/etc/pgpool/follow_primary.sh %d %h %p %D %m %H %M %P %r %R %N %S'
listen_addresses = '*'
pcp_listen_addresses = '*'
pid_file_name = '/var/run/pgpool/pgpool.pid'
socket_dir = '/var/run/pgpool'
pcp_socket_dir = '/var/run/pgpool'
wd_ipc_socket_dir = '/var/run/pgpool'
sr_check_user = 'pgpool'
recovery_user = 'pgsql'
health_check_user = 'pgpool'
enable_pool_hba = off
pool_passwd = 'pool_passwd'
authentication_timeout = 30
allow_clear_text_frontend_auth = off
ssl = on
ssl_key = '/etc/pgpool/ssl/pgpool.key'
ssl_cert = '/etc/pgpool/ssl/pgpool.pem'
ssl_ca_cert = '/etc/ssl/certs/ca-bundle.crt'
ssl_ciphers = 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DHE-DSS-AES256-GCM-SHA384:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!3DES:!MD5:!PSK'
ssl_prefer_server_ciphers = on
ssl_ecdh_curve = 'prime256v1'
num_init_children = 32
max_pool = 4
listen_backlog_multiplier = 2
serialize_accept = off
reserved_connections = 0
child_life_time = 300
child_max_connections = 50
connection_life_time = 0
client_idle_limit = 10
log_destination = 'syslog'
log_line_prefix = '%a: '
log_connections = off
log_hostname = on
log_statement = off
log_per_node_statement = off
log_client_messages = off
syslog_facility = 'LOCAL2'
syslog_ident = 'pgpool'
connection_cache = on
load_balance_mode = on
ignore_leading_white_space = on
allow_sql_comments = on
disable_load_balance_on_write = 'transaction'
statement_level_load_balance = on
sr_check_period = 10
delay_threshold = 10000000
log_standby_delay = 'if_over_threshold'
health_check_period = 5
health_check_timeout = 20
health_check_max_retries = 2
health_check_retry_delay = 1
failover_command = '/etc/pgpool/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'
failback_command = '/etc/pgpool/failback.sh %d %h %p %D %m %H %M %P %r %R %N %S'
failover_on_backend_error = off
detach_false_primary = on
search_primary_node_timeout = 300
auto_failback = on
recovery_1st_stage_command = 'recovery_1st_stage'
recovery_timeout = 900
ping_path = '/bin'
wd_priority = 1
failover_when_quorum_exists = on
failover_require_consensus = on
allow_multiple_failover_requests_from_node = off
enable_consensus_with_half_votes = on
wd_interval = 10
wd_heartbeat_keepalive = 2
wd_heartbeat_deadtime = 30