Re: FDW and BDR
От | Tom Lane |
---|---|
Тема | Re: FDW and BDR |
Дата | |
Msg-id | 23691.1441197247@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: FDW and BDR (Craig Ringer <craig@2ndquadrant.com>) |
Список | pgsql-general |
Craig Ringer <craig@2ndquadrant.com> writes: > On 2 September 2015 at 18:46, Willy-Bas Loos <willybas@gmail.com> wrote: >> I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR >> enabled databases. And other FDW and FTS related commands too. > Correct. > The reason for this is that BDR replicates at a database level, but > CREATE SERVER and CREATE USER MAPPING are global, affecting all > databases on a PostgreSQL install. BDR can't therefore guarantee to > replicate CREATE SERVER to other nodes, since it might get run on a > non-BDR-enabled database. Uh ... what? I do not know what the actual reason for this restriction is, but that explanation is nonsense. There are no shared catalogs involved with FDWs. regards, tom lane
В списке pgsql-general по дате отправления: