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 1mpssQ-0005RY-7t for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 14:03:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpssP-0003PO-2t for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 14:03:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpssO-0003PF-O3 for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 14:03:56 +0000 Received: from mout.perfora.net ([74.208.4.197]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpssM-0007vs-7M for pgsql-admin@postgresql.org; Wed, 24 Nov 2021 14:03:56 +0000 Received: from [192.168.1.167] ([98.169.214.209]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M5dpW-1mRmSE3Fyi-00xeQI; Wed, 24 Nov 2021 15:03:50 +0100 Subject: Re: To: Firthouse banu Cc: pgsql-admin@postgresql.org References: From: MichaelDBA Message-ID: <6cb32d43-75d1-b896-5267-48d75c536808@sqlexec.com> Date: Wed, 24 Nov 2021 09:03:48 -0500 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.52 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Provags-ID: V03:K1:ItKTPbjP47sgCtoHM3Co+kPJESEFHZYoaheD2bprlbOjbaMulCK CjwPoKM5u+MfaYakms/eXJe1v+mmow8uuMIJcgpOAtJv3YTBtI0DaTeJ2dHQCWzR7wqxDqJ j3s5e0mKsucYfnsxlgFq8ztAf7mz2sXZD9xDAL1ed9PhJaxvz9oljAuS8+OCjeBcHu45yc1 /cD1PjopqnvdJFlJpBIbA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:EiuAuwme1jw=:ihFpjb+gL/bql/Pjr1q4aF otT7OK4uZABqrW8PrdSTgx9GgK8deRWxUpXGkK/2JNPGSmxtyYK7ND+w7rDKJ2D4eVlqDIUnq 8ODNh3SwnnOzedVDJG39KclPXLDiIvDbGR6IfJrbGqjLR/yYeyTH6u6BPStb6/LiwjpA55RRL Cdbr3xbsJPDJ6hQHfkT6eFnphyHHba89PMBZGcmq/95mYOuUjllx6YMT42Agn8+d0rxDiQHO5 JsR50MalsPQ7yZ8YUCKDTurqq6M/Y7RanC+lCRpC+swBZxiyY/7ftDsKI++ITYcLk10b9ieS2 /4ybBYCapFePQ2HSAXP5ZQj2UEx5j2TPqR4x9PmgJB6eBPx4SlAJ0iPpU+GT6GRambr19u9Ce VBP020EyzxTyFVAFWZtbUbptaGyff2ire9+JCD4/s0k5n580N0+GcH4jIb4V8e9TJYFofXtJ6 2k7vSjtZJ2JCg5dI7ZtAxWCzJVD7/35hX+0TLEkQv7CZ2hzFca+FzIAjgjVyk36x7m5bJIS7K RA+YRvVyRNTFc302VPA61Gz7phfBFQz0XgweVGsbcWNRsO4djMFhAaNgDKAcIsp+Pg/aeb+Es NSppw9Kk98tbtyYNhOm5fjsy6yI3ovtRwuOQmRWtSBCMOMsV3WulgVsWw1GNpESBDNj+7ChJa Pi8qyMS2QmgJ1HrrqAITZ5F/QfZSDA/aCRnNrjr3utrQ+RWOmKwG7958f4S5Tx2e3DQDUgN5L DHtiZ8ekrVNMv/9v List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk You do understand that multi-master replication is not acid-compliant and the implications of that, right? It only works well for "read globally, write locally" scenarios. Regards, Michael Vitale Firthouse banu wrote on 11/24/2021 4:18 AM: > Hi team, > > The best open source tool to achieve Multi master replication in > Postgres ?? > I tried with pglogical but sequence are not replicated properly. > > Please do let me know best tool for this I have 5 servers all should > be in sync with data. > > Thanks > Firrhouse