首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Repmgr未能在claster中注册待机,我错过了什么?

Repmgr未能在claster中注册待机,我错过了什么?
EN

Stack Overflow用户
提问于 2017-08-09 16:04:43
回答 1查看 968关注 0票数 0

repmgr的问题:failed to register in claster

请告诉我我错过了什么?

主配置:

代码语言:javascript
复制
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

待机配置:

代码语言:javascript
复制
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日志:

代码语言:javascript
复制
[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

但当尝试将节点注册为备用节点时:

代码语言:javascript
复制
-bash-4.2$ repmgr -f /etc/repmgr.conf standby register
ERROR: Node 3 exists already with node_name "replica"
EN

回答 1

Stack Overflow用户

发布于 2017-10-13 10:35:27

nub回答,也许可以帮助1.取消注册待机2.修改用户repmgr将search_path设置为repmgr_test,"$user",public;3.尝试注册

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

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/45584965

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档