Postgres Pro
Downloads
Home   >   mailing lists

Re: Two postgres masters - Mailing list pgsql-admin

From MichaelDBA
Subject Re: Two postgres masters
Date
Msg-id c39bc9aa-18de-9bbf-701c-70a492430fcf@sqlexec.com
Whole thread Raw
In response to Re: Two postgres masters  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view
But be willing to throw away your ACID compliancy when you go to mulit-master mode.  Why? There is no global lock manager across active instances.  PostgreSQL is basically active-passive except for some variations like Postgres XL, etc.

Regards,
Michael Vitale

Yambu wrote on 11/12/2020 7:15 AM:
Yes multi-master

On Thu, Nov 12, 2020 at 1:05 PM Juan José Santamaría Flecha <juanjo.santamaria@gmail.com> wrote:

On Thu, Nov 12, 2020 at 8:51 AM Yambu <hyambu@gmail.com> wrote:

Is it possible to have two masters in an environment?

Do you mean multi-master replication?

Regards,

Juan José Santamaría Flecha 

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Save failed records into auxiliary table
Next
From: "David G. Johnston"
Date:
Subject: Re: Save failed records into auxiliary table