From: | Andrew Kerber <andrew(dot)kerber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | PGPOOL Question |
Date: | 2019-07-08 19:41:04 |
Message-ID: | CAJvnOJYkUy2NUtQmBD+vG+8KUM6bBCFqZ9x-Kza04r_ScCU2PQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.'
From | Date | Subject | |
---|---|---|---|
Next Message | Miles Elam | 2019-07-08 20:12:54 | Re: Elastic Search much faster at statistics? |
Previous Message | Peter Geoghegan | 2019-07-08 19:34:14 | Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR |