Re: master and slave at same time

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: Yambu <hyambu(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:27:44
Message-ID: CA+ONtZ7i8dsP6rnANJzrY7HrL-x4Lz90gQQ0-58_AP5h08+ETA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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:31:32 Re: master and slave at same time
Previous Message Yambu 2021-01-06 13:17:55 master and slave at same time