Re: [GENERAL] BDR question on dboid conflicts

2017-10-27 Thread Zhu, Joshua
l.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig Ringer Sent: Thursday, October 26, 2017 7:24 PM To: Zhu, Joshua Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR question on dboid conflicts On 27 October 2017 at 01:15, Zhu, Joshua wrote: > Database oid is used in both bdr.b

Re: [GENERAL] BDR question on dboid conflicts

2017-10-26 Thread Craig Ringer
On 27 October 2017 at 01:15, Zhu, Joshua wrote: > 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. Correct. However, it's used in conjunction with the sysid and node timeline ID. > I notice

[GENERAL] BDR question on dboid conflicts

2017-10-26 Thread Zhu, Joshua
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 bd