listen_addresses = '*'
port = 9999
socket_dir = '/var/run/pgpool-II-91/'

pcp_port = 9898
pcp_socket_dir = '/var/run/pgpool-II-91/'

enable_pool_hba = off
authentication_timeout = 60

ssl = off

num_init_children = 64
max_pool = 4

child_life_time = 0
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0

log_destination = 'stderr'

print_timestamp = on
log_connections = on
log_hostname = on
log_statement = off
log_per_node_statement = off
log_standby_delay = 'if_over_threshold'

syslog_facility = 'LOCAL0'
syslog_ident = 'pgpool'

debug_level = 0

pid_file_name = '/var/run/pgpool-II-91/pgpool.pid'
logdir = '/data/postgresql_db'

connection_cache = off
reset_query_list = 'ABORT; DISCARD ALL'

replication_mode = off

load_balance_mode = off
                                   
backend_hostname0 = 'pgsql_srv_primary'
backend_port0 = 5432               
backend_weight0 = 1
backend_data_directory0 = '/data/postgresql_db'
backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_hostname1 = 'pgsql_srv_standby'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/data/postgresql_db'
backend_flag1 = 'ALLOW_TO_FAILOVER'


master_slave_mode = off
master_slave_sub_mode = 'stream'

parallel_mode = off
enable_query_cache = off

pgpool2_hostname = 'pgsql_srv_standby'
system_db_hostname  = ''
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''

health_check_period = 0

fail_over_on_backend_error = on

recovery_user = 'nobody'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0

relcache_expire = 0

