Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Self-node check method not changed. #847

Open
Rayjun0525 opened this issue Feb 26, 2024 · 0 comments
Open

Self-node check method not changed. #847

Rayjun0525 opened this issue Feb 26, 2024 · 0 comments

Comments

@Rayjun0525
Copy link

Rayjun0525 commented Feb 26, 2024

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]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant