Re: master and slave at same time

Поиск
Список
Период
Сортировка
От Yambu
Тема Re: master and slave at same time
Дата
Msg-id CALhHtcCO2S4ZtQHu8_x_6O4iSTz0BXV31tSFV-UKkKoKZe=9pA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: master and slave at same time  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: master and slave at same time
Список pgsql-admin
If i use logical replication , can i not make it work?

On Wed, Jan 6, 2021 at 3:27 PM Atul Kumar <akumar14871@gmail.com> wrote:
You can use 2 different ports and create 2 instances.

One can act as master and another as slave.

But slave never allow write operation on itself.

If you want both servers to accept write transaction then you should use BDR (postgres) or MMR (Enterprisedb).



Regards 
Atul





On Wednesday, January 6, 2021, Yambu <hyambu@gmail.com> wrote:
Hello

Is it possible to make one server act as master and as a slave at the same time?

This will mean writes are permitted on it.

regards

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

Предыдущее
От: Atul Kumar
Дата:
Сообщение: Re: master and slave at same time
Следующее
От: Yambu
Дата:
Сообщение: Logical replication use cases