Sample Header Ad - 728x90

Removing a FAILED node from repmgr cluster

4 votes
2 answers
8779 views
How do I remove failed node from a PostgreSQL cluster? postgres@db-prod-ms47ox-10-3-104-92:~$ repmgr -f /etc/repmgr/repmgr.conf cluster show Role | Connection String * master | host=db-prod-ms47ox-10-3-105-192.vandelay.io standby | host=db-prod-ms47ox-10-3-104-92.vandelay.io FAILED | host=db-prod-lu8spc-10-3-104-145.vandelay.io Running repmgr cluster cleanup does not remove this node and it appears to stop me from adding a new node into the cluster. This is with repmgr 2.0 and postgres 9.1
Asked by mjallday (171 rep)
Nov 24, 2014, 04:56 PM
Last activity: Aug 11, 2021, 09:43 AM