Re: Can a bdr enabled server belong to more than one bdr group? - Mailing list pgsql-general

From Craig Ringer
Subject Re: Can a bdr enabled server belong to more than one bdr group?
Date
Msg-id CAMsr+YFQOKWNJZV3Mt+hLc-9FBmEPrv6zDKKU6Sjz9KojRiJ8w@mail.gmail.com
Whole thread Raw
In response to Can a bdr enabled server belong to more than one bdr group?  (Dennis <dennisr@visi.com>)
List pgsql-general


On 10 April 2015 at 00:55, Dennis <dennisr@visi.com> wrote:
Can a server instance that has a db in one existing bdr group add that same db to a different/new bdr group so that the db belongs to two different bdr groups at the same time?

e.g.

node 1, db_x, bdr_group (node 1, node 2)
node 2, db_x, bdr_group (node 1, node 2) AND bdr_group(node 2, node 3)
node 3, db_x, bdr_group(node 2, node 3)

Not at the moment, and it's not planned or really designed.

Different DBs can be, but a given DB must be in only one BDR group.

The only way what you describe could work would be if the DB had non-overlapping schemas, i.e. no tables were shared between both. Not only that, but all data types, functions, etc that had the same names would have to have identical definitions.

I don't really see a compelling use case for doing this, and at this point I don't think anyone's thought hard about it.

What _is_ planned (and implemented, but barely tested and not officially supported) is to permit multiple UDR upstreams. So you can receive changesets from multiple upstream servers, which themselves might be BDR nodes.

I'd be interested in a description of your intended use case for what you describe. What problem would it solve for you?


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Regarding bytea column in Posgresql
Next
From: Volkan Unsal
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host