gpt4 book ai didi

database - Repmgr 无法在 claster 中注册备用,我错过了什么?

转载 作者:行者123 更新时间:2023-12-04 19:43:13 25 4
gpt4 key购买 nike

repmgr 的问题:
failed to register in claster

请告诉我,我错过了什么?

主配置:

failover=automatic
follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file'
cluster=cluster1
node=1
node_name=node100
conninfo='host=192.168.22.200 port=6432 user=repmgr dbname=repmgr'
master_response_timeout=30
pg_bindir=/usr/local/bin/
service_start_command = systemctl start postgresql-9.6
service_stop_command = systemctl stop postgresql-9.6
service_restart_command = systemctl restart postgresql-9.6

待机配置:
failover=automatic
follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file'
cluster=cluster1
node=3
node_name=replica
conninfo='host=slav port=6432 user=repmgr dbname=repmgr'
master_response_timeout=30
pg_bindir=/usr/local/bin/
service_start_command = systemctl start postgresql-9.6
service_stop_command = systemctl stop postgresql-9.6
service_restart_command = systemctl restart postgresql-9.6

REPMGR 日志:
[2017-08-09 10:36:37] [WARNING] No record found for node 3 
[2017-08-09 10:36:37] [ERROR] No metadata record found for this node - terminating
[2017-08-09 10:36:37] [HINT] Check that 'repmgr (master|standby) register' was executed for this node

但是当尝试将节点注册为备用时:
-bash-4.2$ repmgr -f /etc/repmgr.conf standby register
ERROR: Node 3 exists already with node_name "replica"

最佳答案

小回答,也许有帮助
1.注销待命
2. ALTER USER repmgr SET search_path TO repmgr_test, "$user", public;
3.尝试注册

conninfo='host=slav 端口.... 也使用 ip

关于database - Repmgr 无法在 claster 中注册备用,我错过了什么?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/45584965/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com