Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdEDJ-0005Yy-Mm for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 15:08:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kdEDI-0003nD-Do for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 15:08:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdEBH-0007aP-7D for pgsql-admin@lists.postgresql.org; Thu, 12 Nov 2020 15:06:35 +0000 Received: from mout.perfora.net ([74.208.4.197]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdEBB-0007Mb-Bl for pgsql-admin@lists.postgresql.org; Thu, 12 Nov 2020 15:06:33 +0000 Received: from [192.168.1.165] ([72.205.30.64]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M5ukJ-1kNd8N2Kdd-00xqZa; Thu, 12 Nov 2020 16:06:26 +0100 Subject: Re: Two postgres masters To: Yambu Cc: =?UTF-8?Q?Juan_Jos=c3=a9_Santamar=c3=ada_Flecha?= , Pgsql-admin References: From: MichaelDBA Message-ID: Date: Thu, 12 Nov 2020 10:06:23 -0500 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.36 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------2F5E515A6F69E61C0FE838BA" Content-Language: en-US X-Provags-ID: V03:K1:5YO9HeZms+CBVez/xQS8Oe+2872T2oMBpaLVe/ojPCcX0CxsSmQ f8rIiHRKrcRDzIPFwa1MdidD0ltnnd1HWHBdcm0zCC+3Q3eVcPt29QhNdnBpJv9+tFajqX1 yJVw/j/OPQggaxac38URqPVsbYhUpbjINlBuVArHk58P+HQISCmQzbBtjWGfxA1LQcwuHQR TdkM2SxbufBOhqk9B5F1w== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:8NAMUvGPHE8=:uAbpTw0pse4w+BAI9CXVDY 9caNpa61LQm6uh54u3ggT+2ZvwWU/p0Zk9C16FlPt2rWSZinYdfK93kLBVteSIU2TY+QPn5Eu cRz5XX2k8fjjRg9GGBltg7oqtN3bc/YKZpjNjvkEXIqFjhicbPSqJLYQbeU4vHRxsWoxiEPFy mWWqhFSvP23fnGK07PymA/mOsCkJPp5tUnDZigGopMdmY46r8JWL4wOQtNVLz/nAKYC9OO6Mw fE6XtkCULgXmxgkgQOPfAX1xOM6D3QuPl/+FclrACZTUBH7eMyfNOkQLzFr22F91iwM8YtJgO ZwY0qwyQs64qVEnw3VGSQNIh6ev3e5RzVJtLHDPEVY2H0QjfEfPunFcDKTEjFR+7GAMiauka6 efK+BzxdJz9Ycv22OoxuUdPkGDJWztg0rySPaYRWTyGbs0j2iFFKumc5tzs732q9Ut+8/66eB A55pXw/MsA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------2F5E515A6F69E61C0FE838BA Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > > wrote: > > > On Thu, Nov 12, 2020 at 8:51 AM Yambu > wrote: > > > Is it possible to have two masters in an environment? > > > Do you mean multi-master replication? > > Regards, > > Juan José Santamaría Flecha > --------------2F5E515A6F69E61C0FE838BA Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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 

--------------2F5E515A6F69E61C0FE838BA--