<div dir="ltr"><div><br></div><div style>I am running postgres 9.2.6 in streaming replication mode with pgpool 3.3.1 in master slave mode. I have db1 with postgres and pgpool, and db2 with postgres and pgpool. The delegate/floating IP is 10.10.10.234. When I have one of the db's as both master database and master pgpool with the ip bound to it, and a client connected in using the delegate, and I reboot db2 (the standby), the client looses their connection. Is this expected? I did not expect for the client to see any impact when I reboot the standby postgres/pgpool server. Below is my config. </div>
<div style><br></div><div style>Thanks!</div><div><br></div><div><br></div><div><br></div><div style>My config:</div><div><br></div><div>listen_addresses = '*'</div><div>port = 9999</div><div>socket_dir = '/var/run/pgpool'</div>
<div>pcp_port = 9898</div><div>pcp_socket_dir = '/var/run/pgpool'</div><div>pcp_timeout = 100</div><div>backend_hostname0 = '10.10.10.133'</div><div>backend_port0 = 5432</div><div>backend_weight0 = 1</div>
<div>backend_data_directory0 = '/var/lib/pgsql/9.2/data'</div><div>backend_flag0 = 'ALLOW_TO_FAILOVER'</div><div>backend_hostname1 = '10.10.10.233'</div><div>backend_port1 = 5432</div><div>backend_weight1 = 1</div>
<div>backend_data_directory1 = '/var/lib/pgsql/9.2/data'</div><div>backend_flag1 = 'ALLOW_TO_FAILOVER'</div><div>enable_pool_hba = on</div><div>authentication_timeout = 15</div><div>ssl = off</div><div>num_init_children = 32</div>
<div>max_pool = 4</div><div>child_life_time = 300</div><div>child_max_connections = 0</div><div>connection_life_time = 0</div><div>client_idle_limit = 0</div><div>log_destination = 'stderr'</div><div>print_timestamp = on</div>
<div>log_connections = off</div><div>log_hostname = off</div><div>log_statement = off</div><div>log_per_node_statement = off</div><div>log_standby_delay = 'none'</div><div>syslog_facility = 'LOCAL0'</div><div>
syslog_ident = 'pgpool'</div><div>debug_level = 0</div><div>pid_file_name = '/var/run/pgpool/pgpool.pid'</div><div>logdir = '/var/log/pgpool'</div><div>connection_cache = on</div><div>reset_query_list = 'ABORT; DISCARD ALL'</div>
<div>replication_mode = off</div><div>replicate_select = off</div><div>insert_lock = on</div><div>lobj_lock_table = ''</div><div>replication_stop_on_mismatch = off</div><div>failover_if_affected_tuples_mismatch = off</div>
<div>load_balance_mode = off</div><div>ignore_leading_white_space = on</div><div>white_function_list = ''</div><div>black_function_list = 'nextval,setval'</div><div>master_slave_mode = on</div><div>master_slave_sub_mode = 'stream'</div>
<div>sr_check_period = 0</div><div>sr_check_user = 'health_check'</div><div>delay_threshold = 0</div><div>follow_master_command = ''</div><div>parallel_mode = off</div><div>pgpool2_hostname = ''</div>
<div>system_db_hostname = 'localhost'</div><div>system_db_port = 5432 </div><div>system_db_dbname = 'pgpool'</div><div>system_db_schema = 'pgpool_catalog'</div><div>system_db_user = 'pgpool'</div>
<div>health_check_period = 5</div><div>health_check_timeout = 20</div><div>health_check_user = 'health_check'</div><div>health_check_max_retries = 1</div><div>health_check_retry_delay = 1</div><div>failover_command = '/var/lib/pgsql/9.2/failover.sh %d %P %H %R'</div>
<div>failback_command = ''</div><div>fail_over_on_backend_error = on</div><div>search_primary_node_timeout = 10 </div><div>recovery_user = 'nobody'</div><div>recovery_password = ''</div><div>recovery_1st_stage_command = '/var/lib/pgsql/9.2/online_recovery.sh'</div>
<div>recovery_2nd_stage_command = ''</div><div>recovery_timeout = 90</div><div>client_idle_limit_in_recovery = 0</div><div>use_watchdog = on </div><div>trusted_servers = ''</div><div>delegate_IP = '10.10.10.234'</div>
<div>wd_hostname = '10.10.10.233'</div><div>wd_port = 9000</div><div>wd_interval = 3 </div><div>ping_path = '/bin/'</div><div>ifconfig_path = '/var/lib/pgsql/sbin/'</div><div>if_up_cmd = 'ifconfig eth1:0 inet 10.10.10.234 netmask 255.255.255.128'</div>
<div>if_down_cmd = 'ifconfig eth1:0 down'</div><div>arping_cmd = 'arping -U $_IP_$ -w 1'</div><div>wd_life_point = 3</div><div>wd_lifecheck_query = 'SELECT 1'</div><div>wd_lifecheck_dbname = 'template1'</div>
<div>wd_lifecheck_user = 'health_check'</div><div>wd_lifecheck_password = 'foo1234'</div><div>other_pgpool_hostname0 = '10.10.10.133'</div><div>other_pgpool_port0 = 9999</div><div>other_wd_port0 = 9000</div>
<div>relcache_expire = 0</div><div>relcache_size = 256</div><div>check_temp_table = on</div><div>memory_cache_enabled = off</div><div>memqcache_method = 'shmem'</div><div>memqcache_memcached_host = 'localhost'</div>
<div>memqcache_memcached_port = 11211</div><div>memqcache_total_size = 67108864</div><div>memqcache_max_num_cache = 1000000</div><div>memqcache_expire = 0</div><div>memqcache_auto_cache_invalidation = on</div><div>memqcache_maxcache = 409600</div>
<div>memqcache_cache_block_size = 1048576</div><div>memqcache_oiddir = '/var/log/pgpool/oiddir'</div><div>white_memqcache_table_list = ''</div><div>black_memqcache_table_list = ''</div><div>wd_heartbeat_port = 9694</div>
<div>wd_heartbeat_deadtime = 20</div><div>heartbeat_destination0 = '10.10.10.133'</div><div>heartbeat_destination_port0 = 9694</div><div>heartbeat_device0 = 'eth1'</div></div>