I have a 3 node vCloud Director cluster, running as 1 primary and 2 standby nodes.
The repmgr cluster show command returns results you would expect to see.
If I run the repmgr cluster matrix however, I see that the node cannot SSH to the other nodes and therefor returns unknown status for the other 2 nodes.
root@node3 [ ~ ]# sudo -i -u postgres /opt/vmware/vpostgres/10/bin/repmgr -f /opt/vmware/vpostgres/10/etc/repmgr.conf cluster show
ID | Name | Role | Status | Upstream | Location | Connection string
----+---------+---------+-----------+----------+----------+---------------------------------------------
17192 | node3 | standby | running | node1 | default | host=192.168.1.20 user=repmgr dbname=repmgr
19028 | node1 | primary | * running | | default | host=192.168.1.21 user=repmgr dbname=repmgr
30994 | node2 | standby | running | node1 | default | host=192.168.1.22 user=repmgr dbname=repmgr
root@node3 [ ~ ]# sudo -i -u postgres /opt/vmware/vpostgres/10/bin/repmgr -f /opt/vmware/vpostgres/10/etc/repmgr.conf cluster matrix
INFO: connecting to database
Name | Id | 17192 | 19028 | 30994
--------+----+----+----+----
node3 | 17192 | * | * | *
node1 | 19028 | ? | ? | ?
node2 | 30994 | ? | ? | ?
WARNING: following problems detected:
node 19028 inaccessible via SSH
node 30994 inaccessible via SSH
Where do I add the SSH key to allow passwordless SSH between the nodes?
Managed to find it. /var/vmware/vpostgres/current/.ssh./known_hosts. Added the key from each host to this on each of the nodes and now cluster crosscheck is completing succesfully.
Managed to find it. /var/vmware/vpostgres/current/.ssh./known_hosts. Added the key from each host to this on each of the nodes and now cluster crosscheck is completing succesfully.