Postgres Pro
Downloads
Home   >   mailing lists

Re: master and slave at same time - Mailing list pgsql-admin

From Yambu
Subject Re: master and slave at same time
Date
Msg-id CALhHtcCO2S4ZtQHu8_x_6O4iSTz0BXV31tSFV-UKkKoKZe=9pA@mail.gmail.com
Whole thread Raw
In response to Re: master and slave at same time  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: master and slave at same time
List pgsql-admin
Tree view
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 by date:

Previous
From: Atul Kumar
Date:
Subject: Re: master and slave at same time
Next
From: Yambu
Date:
Subject: Logical replication use cases