hard-coded settings that are not default values

[k-ta-yamada]

example

• master_slave_mode
• load_balance_mode

cd cookbooks/pgpool-II
diff files/etc/pgpool-II/pgpool.conf templates/etc/pgpool-II/pgpool.conf.erb

[k-ta-yamada]

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