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

standby switchover fails with PostgreSQL 12 / repmgr 5.0 #757

Closed
vkk74in opened this issue Aug 1, 2022 · 4 comments
Closed

standby switchover fails with PostgreSQL 12 / repmgr 5.0 #757

vkk74in opened this issue Aug 1, 2022 · 4 comments

Comments

@vkk74in
Copy link

vkk74in commented Aug 1, 2022

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 ""

@vkk74in
Copy link
Author

vkk74in commented Aug 1, 2022

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.

@guruguruguru
Copy link

guruguruguru commented Oct 17, 2022

Did you provide SSH Keys for passwordless logins between the two nodes for the postgres/repmgr user?

@castlhe
Copy link

castlhe commented Jan 11, 2023

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

@martinmarques
Copy link
Collaborator

@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

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

4 participants