Pgpool.conf ==

listen_addresses = '*'
port = 9999
pcp_listen_addresses = '*'
backend_hostname0 = 'ha0001'
backend_port0 = 5432
backend_weight0 = 1
backend_hostname1 = 'ha0002'
backend_port1 = 5432
backend_weight1 = 1
backend_hostname2 = 'ha0003'
backend_port2 = 5432
backend_weight2 = 1
load_balance_mode = 'on'
master_slave_mode = 'on'
master_slave_sub_mode = 'stream'
sr_check_period = 10
sr_check_user = 'monitor'
sr_check_password = 'Monitor@321'
sr_check_database = 'monitor'
delay_threshold = 10240
allow_clear_text_frontend_auth = 'on'
pid_file = '/var/run/pgpool/pgpool.pid'
logging_collector = on
log_directory = '/u01/app/admin/Data/PG_LOGS'
log_filename = 'pgpool.log'
num_init_children = 30
enable_pool_hba = on
pool_passwd = '/usr/local/etc/pool_passwd'
health_check_period = 30
health_check_timeout = 20
health_check_user = 'pgbigboss'
health_check_password = 'pgbigboss'
health_check_database = 'postgres'
health_check_max_retries = 3
health_check_retry_delay = 1
connect_timeout = 10000
statement_level_load_balance = on
use_watchdog = on
delegate_ip = '10.127.1.18'
if_up_cmd = '/sbin/ip addr add $_IP_$/24 dev eth0 label eth0:1'
if_down_cmd = '/sbin/ip addr del $_IP_$/24 dev eth0'
arping_cmd = '/usr/sbin/arping -U $_IP_$ -w 1 -I eth0 -c 3'
hostname0 = 'ha0001'
wd_port0 = 9000
pgpool_port0 = 9999
hostname1 = 'ha0002'
wd_port1 = 9000
pgpool_port1 = 9999
hostname2 = 'ha0003'
wd_port2 = 9000
pgpool_port2 = 9999
wd_lifecheck_method = 'heartbeat'
wd_interval = 10
heartbeat_hostname0 = 'ha0001'
heartbeat_port0 = 9694
heartbeat_device0 = ''
heartbeat_hostname1 = 'ha0002'
heartbeat_port1 = 9694
heartbeat_device1 = ''
heartbeat_hostname2 = 'ha0003'
heartbeat_port2 = 9694
heartbeat_device2 = ''
wd_heartbeat_keepalive = 2
wd_heartbeat_deadtime = 30
#trusted_servers = ''
trusted_server_command = 'ping -q -c3 %h'
backend_clustering_mode = 'streaming_replication'

[root@staging-ha0001 etc]#

#################################################
pgpool_node_id

[root@staging-ha0001 etc]# cat pgpool_node_id
0
[root@staging-ha0001 etc]#

#########################

pool_hba.conf

local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               trust
host    all         all         10.127.1.10/32        trust
host    all         all         10.127.1.11/32         trust
host    all         all         10.127.1.13/32         trust

########################

pcp.conf

pgbigboss:66c7766130b3cf99e9ed3fde1a9f59de