Thread: BDR - Remove & Join
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
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.
Regards and thank you.
On 10 November 2015 at 05:10, Will McCormick <wmccormick@gmail.com> wrote: > 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'. [snip] > We are using the following version of bdr: 0.9.2.0 Please update to 0.9.3, which fixes this issue, per https://github.com/2ndQuadrant/bdr/issues/126 -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services