vCloud Director vpostgres HA cluster – SSH inter-node failing

This post was originally published on this site

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?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.