listen_addresses = '*'
backend_weight0 = 0
backend_flag0 = 'DISALLOW_TO_FAILOVER'
backend_weight1 = 1
backend_flag1 = 'DISALLOW_TO_FAILOVER'
log_hostname = on
log_statement = on
log_per_node_statement = on
log_client_messages = on
pid_file_name = 'pgpool.pid'
sr_check_period = 0
sr_check_database = 'postgres'
health_check_period = 1
health_check_database = 'postgres'
hostname0 = ''
allow_clear_text_frontend_auth = 'on'
logging_collector = 'on'
log_filename = 'btpgpool-%d_%H%M%S.log'
client_min_messages = 'error'
log_min_messages = 'FATAL'
log_per_node_statement = 'on'
log_client_messages = 'on'
log_hostname = 'on'
log_connections = 'on'
log_disconnections = 'on'
log_error_verbosity  = 'verbose'
client_idle_limit =  1800
connection_life_time = 0
max_pool = 8
log_truncate_on_rotation = 'on'

ssl = 'on'
enable_pool_hba = 'on'


ssl_ca_cert = '/var/lib/pgsql/pgpool/cert/ca.crt'
ssl_prefer_server_ciphers = on


ssl_key = '/var/lib/pgsql/pgpool/cert/tls.key'
ssl_cert = '/var/lib/pgsql/pgpool/cert/tls.crt'


failover_on_backend_error = 'off'

backend_data_directory0 = '/apps/pgdata01/15/51901'
backend_data_directory1 = '/apps/pgdata01/15/51901'
backend_data_directory2 = '/apps/pgdata01/15/51901'
backend_application_name0= 'primary-vm-pg'
backend_application_name1= 'stby-vm-pg'
backend_application_name2= 'stby-vm-pg'
backend_hostname0 = '1********1'
backend_port0 = 5***1
backend_hostname1 = '1********5'
backend_port1 = 5***1
backend_hostname2 = '1********6'
backend_port2 = 5***1
port = 5***2
log_directory = '/var/lib/pgsql/pgpool/log'
load_balance_mode  = 'on'
sr_check_user = 'postgres'
sr_check_password = '***'
health_check_user = 'postgres'
health_check_password = '***'
num_init_children = 100