Re: master and slave at same time

From: Yambu <hyambu(at)gmail(dot)com>
To: Atul Kumar <akumar14871(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: master and slave at same time
Date: 2021-01-06 13:31:32
Message-ID: CALhHtcCO2S4ZtQHu8_x_6O4iSTz0BXV31tSFV-UKkKoKZe=9pA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)gmail(dot)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
>>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2021-01-06 13:33:22 Logical replication use cases
Previous Message Atul Kumar 2021-01-06 13:27:44 Re: master and slave at same time