k-ta-yamada
commented
7 years ago diff files/etc/pgpool-II/pgpool.conf.sample-stream templates/etc/pgpool-II/pgpool.conf.erb -y --left-column --suppress-common-line -w -B
listen_addresses = 'localhost' | listen_addresses = '*'
socket_dir = '/tmp' | socket_dir = '<%= @pgpool_conf[:socket_dir] %>'
pcp_socket_dir = '/tmp' | pcp_socket_dir = '<%= @pgpool_conf[:pcp_socket_dir] %>'
backend_hostname0 = 'host1' | backend_hostname0 = '<%= @backend_prefix %><%= @pgpool_conf[:
backend_data_directory0 = '/data' | backend_data_directory0 = '<%= @pgpool_conf[:backend_data_dir
#backend_hostname1 = 'host2' | backend_hostname1 = '<%= @backend_prefix %><%= @pgpool_conf[:
#backend_port1 = 5433 | backend_port1 = 5432
#backend_weight1 = 1 | backend_weight1 = 1
#backend_data_directory1 = '/data1' | backend_data_directory1 = '<%= @pgpool_conf[:backend_data_dir
#backend_flag1 = 'ALLOW_TO_FAILOVER' | backend_flag1 = 'ALLOW_TO_FAILOVER'
enable_pool_hba = off | enable_pool_hba = on
log_destination = 'stderr' | log_destination = '<%= @pgpool_conf[:log_destination] %>'
log_connections = off | log_connections = on
log_hostname = off | log_hostname = on
log_statement = off | log_statement = on
log_per_node_statement = off | log_per_node_statement = on
logdir = '/tmp' | logdir = '<%= @pgpool_conf[:logdir] %>'
sr_check_user = 'nobody' | sr_check_user = '<%= @pgpool_conf[:sr_check_user] %>'
sr_check_password = '' | sr_check_password = '<%= @pgpool_conf[:sr_check_password] %>'
sr_check_database = 'postgres' | sr_check_database = '<%= @pgpool_conf[:sr_check_database] %>'
health_check_period = 0 | health_check_period = 5
health_check_user = 'nobody' | health_check_user = '<%= @pgpool_conf[:health_check_user] %>'
health_check_password = '' | health_check_password = '<%= @pgpool_conf[:health_check_passw
health_check_max_retries = 0 | health_check_max_retries = 10
failover_command = '' | failover_command = '<%= @pgpool_conf[:failover_command] %>'
recovery_user = 'nobody' | recovery_user = '<%= @pgpool_conf[:recovery_user] %>'
recovery_password = '' | recovery_password = '<%= @pgpool_conf[:recovery_password] %>'
recovery_1st_stage_command = '' | recovery_1st_stage_command = '<%= @pgpool_conf[:recovery_1st_
recovery_2nd_stage_command = '' | recovery_2nd_stage_command = '<%= @pgpool_conf[:recovery_2nd_
use_watchdog = off | use_watchdog = on
wd_hostname = '' | wd_hostname = '<%= @backend_prefix %><%= @depend_on_hostname[
wd_ipc_socket_dir = '/tmp' | wd_ipc_socket_dir = '<%= @pgpool_conf[:wd_ipc_socket_dir] %>'
delegate_IP = '' | delegate_IP = '<%= @pgpool_conf[:delegate_ip] %>'
if_up_cmd = 'ip addr add $_IP_$/24 dev eth0 label eth0:0' | if_up_cmd = 'ip addr add $_IP_$/24 dev <%= @pgpool_conf[:nic_
if_down_cmd = 'ip addr del $_IP_$/24 dev eth0' | if_down_cmd = 'ip addr del $_IP_$/24 dev <%= @pgpool_conf[:ni
arping_cmd = 'arping -U $_IP_$ -w 1' | arping_cmd = 'arping -U $_IP_$ -w 1 -I <%= @pgpool_conf[:nic_
heartbeat_destination0 = 'host0_ip1' | heartbeat_destination0 = '<%= @backend_prefix %><%= @depend_o
#heartbeat_destination1 = 'host0_ip2' | #heartbeat_destination1 = '<%= @backend_prefix %><%= @depend_
#other_pgpool_hostname0 = 'host0' | other_pgpool_hostname0 = '<%= @backend_prefix %><%= @depend_o
#other_pgpool_port0 = 5432 | other_pgpool_port0 = 9999
#other_wd_port0 = 9000 | other_wd_port0 = 9000
#other_pgpool_hostname1 = 'host1' | #other_pgpool_hostname1 = '<%= @backend_prefix %><%= @depend_
#other_pgpool_port1 = 5432 | #other_pgpool_port1 = 9999
example