Re: Can a bdr enabled server belong to more than one bdr group?

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Can a bdr enabled server belong to more than one bdr group?
Дата
Msg-id CAMsr+YFQOKWNJZV3Mt+hLc-9FBmEPrv6zDKKU6Sjz9KojRiJ8w@mail.gmail.com
обсуждение исходный текст
Ответ на Can a bdr enabled server belong to more than one bdr group?  (Dennis <dennisr@visi.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Regarding bytea column in Posgresql
Следующее
От: Volkan Unsal
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host