EnterpriseDB/repmgr

Self-node check method not changed.

Opened this issue · 1 comments

Even if the connection_check_type setting in repmgr is changed to query, the self-check method is still performed using PQping.
Is there a way to change all connection check methods to a method other than query or PQping?

repmgr : 5.3.3
PG : 13.3
node : Primary - Standby (2node)

Primary repmgr.conf

node_id=1
node_name=[Host Name]
conninfo='host=[IP] user=repmgr dbname=repmgr connect_timeout=2'
data_directory='/data'
use_replication_slots=yes
connection_check_type=query
log_level=INFO
log_facility=STDERR
log_file='/data/pg_logs/repmgrd.log'
pg_bindir='/postgres/bin'
pg_ctl_options='-s -l /dev/null'
ssh_options='-q -o ConnectTimeout=10'
primary_follow_timeout=60
failover=automatic
priority=100
reconnect_attempts=6
reconnect_interval=10
promote_command='repmgr standby promote -f /repmgr.conf --log-to-file'
follow_command='repmgr standby follow -f /repmgr.conf -W --upstream-node-id=%n --log-to-file'
monitoring_history=true

Standby repmgr.conf

node_id=2
node_name=[Host Name]
conninfo='host=[IP] user=repmgr dbname=repmgr connect_timeout=2'
data_directory='/data'
use_replication_slots=yes
connection_check_type=query
log_level=INFO
log_facility=STDERR
log_file='/data/pg_logs/repmgrd.log'
pg_bindir='/postgres/bin'
pg_ctl_options='-s -l /dev/null'
ssh_options='-q -o ConnectTimeout=10'
primary_follow_timeout=60
failover=automatic
priority=100
reconnect_attempts=6
reconnect_interval=10
promote_command='repmgr standby promote -f /repmgr.conf --log-to-file'
follow_command='repmgr standby follow -f /repmgr.conf -W --upstream-node-id=%n --log-to-file'
monitoring_history=true

repmgr daemon log

[2024-00-00 14:12:10] [WARNING] unable to ping "host=[Standby IP] user=repmgr dbname=repmgr connect_timeout=2"
[2024-00-00 14:12:10] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
[2024-00-00 14:12:10] [WARNING] connection to node "[Standby Host name]" (ID: 2) lost
[2024-00-00 14:12:10] [DETAIL]

Can't someone give me a solution to this problem?
PQping() returned "PQPING_NO_RESPONSE" Event of unknown cause.