I know this is the wrong list for this question, but the pgpool list doesnt appear to be working currently.
I am hoping someone on this list can point me to an answer. I have a fairly (I thought) straightforward pgpool setup, the backend is postrgresql database that is streaming to a hot standby. I am testing the failover, but when I shutdown the primary database instance and open the standby database instance for read/write, i get this message. "health check failed on node 0 but failover is disallowed for the node". What setting am I missing here? Applicable section from the log: Jul 5 10:45:14 pgpool1 pgpool-II-10[32640]: [13-1] 2019-07-05 10:45:14: pid 32640: ERROR: failed to make persistent db connection Jul 5 10:45:14 pgpool1 pgpool-II-10[32640]: [13-2] 2019-07-05 10:45:14: pid 32640: DETAIL: connection to host:"10.12.1.225:5432" failed Jul 5 10:45:14 pgpool1 pgpool-II-10[32640]: [14-1] 2019-07-05 10:45:14: pid 32640: LOG: health check failed on node 0 but failover is disallowed for the node Here are the applicable sections from my pgpool.conf - Backend Connection Settings - backend_hostname0 = '10.12.1.225' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/postgres/data/pgdata' backend_flag0 = 'ALLOW_TO_FAILOVER' backend_hostname1 = '10.12.1.61' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/postgres/data/pgdata' backend_flag1 = 'ALLOW_TO_FAILOVER' master_slave_mode = on master_slave_sub_mode = 'stream' health_check_period = 10 health_check_timeout = 5 health_check_user = 'nobody' health_check_password = '' health_check_max_retries = 0 health_check_retry_delay = 1 connect_timeout = 10000 failover_command = '' failback_command = '' -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
