From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Yambu <hyambu@gmail.com>
Cc: Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Two postgres masters
Date: Thu, 12 Nov 2020 10:06:23 -0500
Message-ID: <c39bc9aa-18de-9bbf-701c-70a492430fcf@sqlexec.com> (raw)
In-Reply-To: <CALhHtcB=a2JKajgaxAdvepD7wB9Zy3u2s4=DJieF=5g2j8iuVQ@mail.gmail.com>
References: <CALhHtcC2yVJ2hshNn26h9CA48fV=Fr974E4vC0q_n1waCv-Q_Q@mail.gmail.com>
<CAC+AXB2L_mSyDx=wLBQVK5xP2db40Dj7ifsbnjGobCCsDKyWNQ@mail.gmail.com>
<CALhHtcB=a2JKajgaxAdvepD7wB9Zy3u2s4=DJieF=5g2j8iuVQ@mail.gmail.com>
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 <mailto:juanjo.santamaria@gmail.com>> wrote:
>
>
> On Thu, Nov 12, 2020 at 8:51 AM Yambu <hyambu@gmail.com
> <mailto: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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: MichaelDBA@sqlexec.com, hyambu@gmail.com, juanjo.santamaria@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Two postgres masters
In-Reply-To: <c39bc9aa-18de-9bbf-701c-70a492430fcf@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox