I have a script which is meant to remove a node from bdr replication. Two nodes in replication node A and node B. The script does the following.
1. On node A - SELECT bdr.bdr_part_by_node_names(ARRAY['node B']);
2. On node A -Checks that the node_status is marked as 'k' in bdr.bdr_nodes
3. I then drop the database on node B
4. On node A I remove all nodes from bdr.bdr_nodes which have a status 'k'
I then run a script which I used to setup replication before removal. The problem I encounter is node B after join in bdr.bdr_nodes is stuck in status 'c'.
Any advice here would be appricated. I'm not sure if I need to drop all databases and reinstall postgres instead of step 3. Or f this should be enough?
We are using the following version of bdr bdr | 16385 | 11 | f | 0.9.2.0 | {18080,18095,18108,18143,18173,18183,18192,18199,18212,18281} | {"","","","","","","","","",""} according to pg_extension.
Please let me know if there is further information I can provide to troubleshoot or if this is a known issue.
Regards and thank you.