backend_clustering_mode = 'streaming_replication'
listen_addresses = '*'
pcp_listen_addresses = '*'
port = 9999
enable_pool_hba = on

sr_check_user = 'pgpool'
sr_check_password = ''

health_check_period = 5
health_check_timeout = 30
health_check_user = 'pgpool'
health_check_password = ''
health_check_max_retries = 3

# backend connection settings
backend_hostname0 = 'db01.nomadesk.org'
backend_application_name0 = 'db01'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/16/data'
backend_flag0 = 'ALLOW_TO_FAILOVER'

backend_hostname1 = 'db02.nomadesk.org'
backend_application_name1 = 'db02'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/16/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'

backend_hostname2 = 'db03.nomadesk.org'
backend_application_name2 = 'db03'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/var/lib/pgsql/16/data'
backend_flag2 = 'ALLOW_TO_FAILOVER'

#logging
log_destination = 'stderr'
logging_collector = on
log_directory = '/var/log/pgpool_log'
log_filename = 'pgpool-%Y-%m-%d_%H%M%S.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 10MB

#debugging
log_statement = on
log_per_node_statement = on

#fail over scripts
failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'
follow_primary_command = '/etc/pgpool-II/follow_primary.sh %d %h %p %D %m %H %M %P %r %R'

#recovery
recovery_user = 'postgres'
recovery_password = ''
recovery_1st_stage_command = 'recovery_1st_stage'

#watchdog
use_watchdog = on
delegate_ip = '192.168.122.20'

wd_lifecheck_method = 'heartbeat'
wd_interval = 10

if_cmd_path = '/sbin'
arping_path = '/usr/sbin'

if_up_cmd = '/usr/bin/sudo /sbin/ip addr add $_IP_$/24 dev enp1s0 label enp1s0:0'
if_down_cmd = '/usr/bin/sudo /sbin/ip addr del $_IP_$/24 dev enp1s0'
arping_cmd = '/usr/bin/sudo /usr/sbin/arping -U $_IP_$ -w 1 -I enp1s0'

hostname0 = 'db01.nomadesk.org'
wd_port0 = 9000
pgpool_port0 = 9999

hostname1 = 'db02.nomadesk.org'
wd_port1 = 9000
pgpool_port1 = 9999

hostname2 = 'db03.nomadesk.org'
wd_port2 = 9000
pgpool_port2 = 9999

wd_heartbeat_keepalive = 2
wd_heartbeat_deadtime = 30

heartbeat_hostname0 = 'db01.nomadesk.org'
heartbeat_port0 = 9694
heartbeat_device0 = ''
heartbeat_hostname1 = 'db02.nomadesk.org'
heartbeat_port1 = 9694
heartbeat_device1 = ''
heartbeat_hostname2 = 'db03.nomadesk.org'
heartbeat_port2 = 9694
heartbeat_device2 = ''

wd_escalation_command = '/etc/pgpool-II/escalation.sh'