standby switchover fails with PostgreSQL 12 / repmgr 5.0
Closed this issue · 4 comments
repmgr standby switchover -f /etc/postgresql/12/main/repmgr.conf --dry-run
WARNING: the following problems were found in the configuration file:
parameter "cluster" is deprecated and will be ignored
NOTICE: checking switchover on node "node2" (ID: 2) in --dry-run mode
WARNING: unable to connect to remote host "" via SSH
ERROR: unable to connect via SSH to host "", user ""
It is a Two Node Cluster
Primary Node: Node1
Standby Node: Node2
I tried to run repmgr standby switchover -f /etc/postgresql/12/main/repmgr.conf --dry-run on StandBy Node and recevied SSH not enabled. I checked SSH status it is active and i am able to ssh to Primary from the StandBy Node.
Did you provide SSH Keys for passwordless logins between the two nodes for the postgres/repmgr user?
Hello i have the same problem:
$ repmgr cluster show
WARNING: the following problems were found in the configuration file:
parameter "cluster" is deprecated and will be ignored
ERROR: no node records were found
HINT: ensure at least one node is registered
@castlhe this is unrelated to the original post. Please remove the cluster parameter to remove the warning message and check that you have the repmgr database configured correctly and you've registered all the nodes via repmgr primary/standby register