Re: Slave-Master replication on top of BDR

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Slave-Master replication on top of BDR
Дата
Msg-id CAMsr+YEQEMCa7MjgU5gpGUCjjbCCXSFM7S4ML+JprF8xwmUVaw@mail.gmail.com
обсуждение исходный текст
Ответ на Slave-Master replication on top of BDR  (Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>)
Список pgsql-general
Дерево обсуждения
On 4 March 2016 at 23:02, Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> wrote:
Hi. I currently have two servers in different geographical locations; both of them are replicating with Postgres-BDR, that's OK. However, I need two more servers to get a read only replication of only some tables from the master ones.

At first I tried with Slony, but it just didn't work(don't know why). I've also checked docs for UDR and pglogical, but don't keep it clear if they can coexist with BDR.


pglogical should theoretically work as both provider and subscriber on BDR, but we haven't put the test infrastructure together to validate that and make it an officially supported configuration yet.  It's certainly desired and on the roadmap.

Using UDR with BDR doesn't work well; the issues we found there are part of why pglogical was created and why it works the way it does.


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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jan de Visser
Дата:
Сообщение: Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?
Следующее
От: "David Bennett"
Дата:
Сообщение: Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?