BDR node removal and rejoin

From: "Zhu, Joshua" <jzhu(at)vormetric(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: BDR node removal and rejoin
Date: 2017-07-07 21:58:31
Message-ID: 8043a694c6cb4db0ab5f5fc03ae65b66@EXUSDAGORL01.INTERNAL.ROOT.TES
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I am having difficulty removing a node from a BDR group (with nodes node1 through node5) then rejoin the group.

Prior to removing a node, the BDR is running fine, query on bdr.bdr_nodes table shows all nodes having the status 'r'.

Here is what I have done for removing node5 and rejoining:

* On node1, do bdr.bdr_part_by_node_names

At this point the status of node5 in bdr.bdr_nodes becomes 'k'

* On node5, do bdr.remove_bdr_from_local_node
* On node5, drop and recreate the database, then rejoin using bdr.bdr_group_join (using the same node name and external dsn)

At this point the status of node5 on node1 though node4 still remains 'k', and the status of node5 on node5 (there is only one record) is 'i', and they stuck at these status codes.
[note: I tried using a different node name on rejoining, same result]

What have I done wrong, what is the correct way of doing removal and rejoining?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guyren Howe 2017-07-08 22:18:39 How to drop column from interrelated views
Previous Message John R Pierce 2017-07-07 18:07:43 Re: Postgresql - commercial version