Part 5 – Unregister a Failed or Unreachable Standby Node in a vCD Database High Availability Cluster

Loading

In this blog, we will remove a standby node that became slightly problematic during our upgrade phases.It so happened i annoyingly changed the SSH password on the node as I connected it for the first time thus causing issues on sync in midst of upgrades.

Blog Series

I will now retire the problematic cell.

1 – Verify the current state of cluster and note the node id of the node that you wish to remove

sudo -i -u postgres /opt/vmware/vpostgres/current/bin/repmgr cluster show

2 – The command will unregister the standby node from our vCD Cluster

sudo -i -u postgres /opt/vmware/vpostgres/current/bin/repmgr standby unregister –node-id=23275 -f /opt/vmware/vpostgres/current/etc/repmgr.conf

3 – Recheck the status of cluster

sudo -i -u postgres /opt/vmware/vpostgres/current/bin/repmgr cluster show

Its recommended we have 3 nodes in a cluster, now we can just deploy a new vCD cell and join to this cluster as per my previous blogs.

(Visited 787 times, 1 visits today)

By Ash Thomas

Ash Thomas is a seasoned IT professional with extensive experience as a technical expert, complemented by a keen interest in blockchain technology.

Leave a Reply