BDR question on dboid conflicts

From: "Zhu, Joshua" <jzhu(at)vormetric(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: BDR question on dboid conflicts
Date: 2017-10-26 17:15:05
Message-ID: ab226de7b032470792266e13e48b7e45@EXUSDAGORL01.INTERNAL.ROOT.TES
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Database oid is used in both bdr.bdr_nodes, as node_dboid, and bdr.bdr_connections, as conn_dboid, also used in construction of replication slot names.

I noticed that when trying to join a bdr group, if the database oid on the new node happens to be the same as that of an node already in the bdr group, the join would fail, and the only way to resolve the conflict that I was able to come up with has been to retry with dropping/recreating the database until the dboid does not conflict with any node already in the group.

Is there a better way to handle this kind of conflicts, especially doing so in a script?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Araújo 2017-10-26 18:05:40 Bucardo syncrun
Previous Message Rob Sargent 2017-10-26 15:17:49 Re: query not scaling