Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6RIz-00BwDn-68 for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 08:45:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s6RIx-00GST1-IW for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 08:45:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6PTD-00FQwD-KF for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 06:47:36 +0000 Received: from mail-southindiaazon11021010.outbound.protection.outlook.com ([52.101.227.10] helo=MA0PR01CU012.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6PKf-000kvE-Nm for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 06:38:47 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Vb9DOmTse6MvFjG+XCmIIw8usaSF/scRwrs9ynwr+mIlQfcvA3kGU5NCbnGXGEarLEDmKJqdAFfyKv1Q+eK4bzGqG4EHWIu1mm7dZcwDP9HJ7BZox326B7jXkYYBSehpZ2zhfSCcxNWh27Lo2LHXX/MwfreipjWhow7v46lfnjbU/cPdwVit6f+LG15ZhR7MD8RMqmPlx8T/Yvi3e53GJrUxG2QlfRlGaFgpwbX/N/EMDzyrNw+Sv/60A7N7BG4KVFpQGiCuhU1Q9xNi9mV1vDxN2DYo2vkuu8aZ0xKCRec2n79L1rg7NZnIPBuUcO57DB6vv2eGI2ICgyshNNEoQw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=YkhgPQhLhHcG5UOgPpZvJAC7cTlWgU1+1S15DgyrWHM=; b=OBuaLUYxMrg93am974kL9F2UjlhFokCFpSAXjwbyrHnT8PEh5sU+Q0E7ogETNPO3+2BJ0Ts2p8cjmQK6eRkurzkkz6HjunTwXV0D1Cad08eL0ol0PI/Nrpcof+wG3B/i4nah4OBzsy6I63SCkZsfi31yQy68B/wz+qdsbyyYH+4Wq96iv0SIAk4ZMFAOXKgaBYXgjOPVUMKJGHLOVDJyIlChwV8a22wY3MciRLJye3MuBEFKps4o4R3Mndaq/cM2qqixm2rq1vjkQ5+KJOh3KcGnxxxgi1JXqsXLArmExkqfDmY4bKDDdh/IEkCMhymYjp1GYpo1UIPnV4ETYevaIQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=exaleapsemi.com; dmarc=pass action=none header.from=exaleapsemi.com; dkim=pass header.d=exaleapsemi.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=exaleapsemi.onmicrosoft.com; s=selector2-exaleapsemi-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=YkhgPQhLhHcG5UOgPpZvJAC7cTlWgU1+1S15DgyrWHM=; b=ytRsQaqVj2Rquzorwuz6D4bRqDj9p2/vV6d9nX8x2Mr2mBTY7KDwMEke5Hle+Ke2+V8apT/kFDUMHwVGg2vQ8ov70ztVz+oqd2hilAxzFRbdhwy4D4AyPHcQgEbvyvUnpp+K19a1UWCr8K6k3a508q6gNzojMF5o0kKvqsD24Zw= Received: from MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM (2603:1096:a01:56::8) by PN2PR01MB9027.INDPRD01.PROD.OUTLOOK.COM (2603:1096:c01:15d::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7544.55; Mon, 13 May 2024 06:38:40 +0000 Received: from MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM ([fe80::4c2a:8b77:1968:7946]) by MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM ([fe80::4c2a:8b77:1968:7946%5]) with mapi id 15.20.7544.052; Mon, 13 May 2024 06:38:39 +0000 From: Vidyashree H S To: Bruce Momjian , Greg Sabino Mullane CC: Kashif Zeeshan , "pgsql-general@lists.postgresql.org" Subject: Re: Postgresql active-active nodes in cluster Thread-Topic: Postgresql active-active nodes in cluster Thread-Index: AQHaodza5WV6l9/kdUWE8aSQG/sZ2LGOvAUAgADCIYCAAA3SgIAAYZQXgATLMLo= Date: Mon, 13 May 2024 06:38:39 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=exaleapsemi.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: MAZPR01MB6815:EE_|PN2PR01MB9027:EE_ x-ms-office365-filtering-correlation-id: 96b04558-35a9-4fe2-2ae2-08dc7317534c x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|366007|376005|1800799015|38070700009; x-microsoft-antispam-message-info: =?iso-8859-1?Q?sPRuUlJuFY1WDr5BIlN6HmMEUN93NCVvH1Lzie4x2bQgOwQPrQBkMp+LD2?= =?iso-8859-1?Q?G4dXd9RXOKbbtI5wImztKFH4cP2ukaEFajWcPOOAuS55qXePNnE6HeQ3tV?= =?iso-8859-1?Q?xN20AaB3oS5qoFMIueuw/nriNQkGjjXPQZLCZDj3A1vXz87XryUL0wPKuM?= =?iso-8859-1?Q?w7GZb2l7/vrWrPelNXqIQo1If64TKaZH8sQpLfTlnPMc/UUzSds1IjKB0k?= =?iso-8859-1?Q?xSdHW+zckrV+hXNW1hjGCjFfjEQtVG9v598QyyUmTYQdWk1JqfP33r7J/q?= =?iso-8859-1?Q?VD8Us2fxafEYA4rnGpUeo29x/uZ8GglSg02QAnTrK/9NVfSCOwp+hNPKTn?= =?iso-8859-1?Q?KzxQYuXAZz0tIKIMn0UVZpWb8cs0euMcvmM1RVAyuDD5wHgMp05t+6PnWn?= =?iso-8859-1?Q?PHWt0ITAqPdpi4gKcuho5XgGcVhWdc1zIPr6sQdMRytEq+Djc87cNW4Xkf?= =?iso-8859-1?Q?3dQkEY9M1K4lie5dP5NEworAGl/mXo60P9y3yI5iQH1dh2kE0Dqm4FNUdF?= =?iso-8859-1?Q?Im/X8UO1He0TDZHrXe50GGGMHJlqsHA/Jz6dNxn0Z9/zyhQTyCjRsKWb4p?= =?iso-8859-1?Q?HuVO3jv3jKPwVLKpyAnjGih4RmeAdPeQghSH8eIu72QcVW9EfZWDL4cqWI?= =?iso-8859-1?Q?PhxDxwLBBGD9Uk8ifzrAAjuxBurhD+z+CirR4Wj3JJdQfQ3L5d4Dxx/6Q+?= =?iso-8859-1?Q?vrRDEbYfL25LYTUUos9QLukfYNULA7vbrIS3fKH5BcNlSpfQ2BgkAKI3Sz?= =?iso-8859-1?Q?HEinocE5SBxf6N0QbXOIMpoX5FClpas2S1Kj/gQD2grkTTnsX+Cf9p8Jr3?= =?iso-8859-1?Q?iu71ZHLMMB7YX4eBz4aPO4cLGlgRvW0hYN5hnd1+UiDJ5T9h8KY3dZlDeI?= =?iso-8859-1?Q?j+1iaXL2Lz/FCZ0Gg03LRM5o/mwxHeS7hJbWwgec15ULZ5nBMVKaUvTGwO?= =?iso-8859-1?Q?LcmpFebOFup1Zv4KF6dZRFw/irpPnRFXlgMS856p/6GOdARNfRtb7n7EPy?= =?iso-8859-1?Q?+NQhmoGM7u4nxdkQz+/Ojv+3tee5ATgAYy6hA8pHQazqDa1d2vWlJpi9Ap?= =?iso-8859-1?Q?5wQoZTd2x66DBJJekmD49ax2M8XVd7nLZw+a9IGHJlsa7sDw/RxXuWhz0J?= =?iso-8859-1?Q?2dIMxHsJmbdIVKU0MQmXW6K9Wz9zTj1Tv4WgZhr8GZ5wwVWBVnGc2H8jpL?= =?iso-8859-1?Q?4nAvDuMkAEXKgtKKUIp6AwIICaL2EmpJH5Sm8FflBMte5B6q3lObbEi8T6?= =?iso-8859-1?Q?GmaCVH69JNkAVs+QD7OGPK24MaCaZASw3m/95yuVjUmXASKLgHXJcqfcPN?= =?iso-8859-1?Q?1MiW31K17VvmnRlF37ZT8Jvo6Q=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(366007)(376005)(1800799015)(38070700009);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?eKRJRE80c8nDgD6atWdfmBIR/fQxwpp0BKtupe8VZtG6MO2m6TubYILLbC?= =?iso-8859-1?Q?N6ekkTdPnLciUQFPoSqkHSygz/w4NIwms1ITwG1stqnp0IXFPTrt9Dww0j?= =?iso-8859-1?Q?zJ9lwhTlLGoLcqK1NIMpxI2EEFe9fMfAYNTxBGgKGQh+qqV6+E6K6lsl8K?= =?iso-8859-1?Q?iXuadyRwvDsBJsZTfU2xRyo7s1ZVS57N1GhgD+bPo76wd+6EO95tqUL337?= =?iso-8859-1?Q?AxtsPyI7o0wHMYRCQxbZknZ5no6FJ2KXIy/XhWLH56YqYUItIa5OVD4N/O?= =?iso-8859-1?Q?Qo9dauf5OODA4GyXr8wbmQ51rmQEwf7is36tjbzoA7ePDS/X7Te/mBw2Aj?= =?iso-8859-1?Q?CXheh5CK7agC5GnPJdaIKS0iccDwc9Q3j/5HP3thM/vmW6/Xl38x2pH0Y3?= =?iso-8859-1?Q?Cvf4TxGOfC3KdUqQYHOetR9q4v6KjYEUqPzJHZeBiaHcSPkpwy8ipRbUdN?= =?iso-8859-1?Q?A1jBiRzH8MVgRYVougkNIRiLoRnjRHNincgtoRqkNQcu/XMMevxBsmBul5?= =?iso-8859-1?Q?bjm7twwEeDNGcJENdHLpVClrk9qeVBtoEVauT7Tkk4OfmBkV/fKHec9jW0?= =?iso-8859-1?Q?H4uMBZOkVEVQECsQXfoJyrgg1SaugXg937uF8q8LfT3ChBJhRvnkEH96ZJ?= =?iso-8859-1?Q?V3WaiA7P0iUA349ktZX6CR/4MrdKg+sBjAQdzzUodpMvq2jgQ1aF0JOOVy?= =?iso-8859-1?Q?peuaN+otDAoWEgMvoEaadR/F2WZqO/6xY3xTrcDwMyHfxk1f6A+tcjdNtC?= =?iso-8859-1?Q?erjd27zwvOIBi0nEY0erEHN1pIxB8AuX1Cni9cj1+3X/Pg4qt0EDq0+AqD?= =?iso-8859-1?Q?D9Egt62NJybpba+rKPTRQgtaZOwpWVAw7mcz0haDViaOeZmAyr8sn8kXX8?= =?iso-8859-1?Q?uO9LPL6ADe0IYmM0OFOIcL83g8WK2lRAXd60wA3VK54mIO/ro97FrrH+m6?= =?iso-8859-1?Q?mZ+GjZl7mS3ytQUkK5ph8cRo/u2l43czPBnjV44cGSHOlqys0ygRoM7POx?= =?iso-8859-1?Q?J1/99+v/AnOKW9zr/SO/b4AOGCV7aC8eM04rOX1qk9k9dVDbZlP3C8jy8F?= =?iso-8859-1?Q?JV0ArJTcpv4F1BTkHFGzAnxz4oGOwerMb10oP69To2EMXvRXBXdaC2alq6?= =?iso-8859-1?Q?uWw1Q9MtYXRgTtuIF9U+aXevjaFDrEcaDN6upO2hop0KXe1emok17mljpT?= =?iso-8859-1?Q?4q0rdZwtHkzlQqovuUWWJcnHQ+bgfPbCGNeJ4/JbYtNQptaxibDA/31mNV?= =?iso-8859-1?Q?cJTmylezDHV8k91qsl6+OGhZudE8KpkX0+mwDrIVuLJDglR/b4nHwbLH2T?= =?iso-8859-1?Q?CnQRPa9GS2Tlj+2qFx+eu3xFduh69C05cTfot+c4Ptom3A2XfMRh6jIxaF?= =?iso-8859-1?Q?YJXQcfASSpMq8fdplZKp+E4mh7/L79XCEqGjjjX2lAex8EihPbZuuXghr7?= =?iso-8859-1?Q?Z4Py877OxfBIkm5JtXBsjTqTWLq0nrIAwIzYhmjSKH1aN66y/QcH3wFjAz?= =?iso-8859-1?Q?KzOjoJha9uQdp2O4rHN0SuRvi544mr+L4LQ/RZQrmkl4b27+L36oU1Crue?= =?iso-8859-1?Q?HrcenTFGsR48EZsHj4YcQRx2lRDxxkQsoXaPedq2vtBU2/nINBxQeEe+MO?= =?iso-8859-1?Q?p52XpTLOMPOaRKMH+d42c6RYQluSS6Ei9r5SePpn3HyacdPRvKspU2hg?= =?iso-8859-1?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_MAZPR01MB6815114742553C2273A15F82FCE22MAZPR01MB6815INDP_" MIME-Version: 1.0 X-OriginatorOrg: exaleapsemi.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 96b04558-35a9-4fe2-2ae2-08dc7317534c X-MS-Exchange-CrossTenant-originalarrivaltime: 13 May 2024 06:38:39.8431 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 34df156e-9bc4-4450-9e80-487c0e7f9471 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 8UA31QoExSW4HbX+CxT3FreUCIMG9Pa4UWJzdnKlFGC/qow/MbyN1o1148wmkrf8Xyj8G42oHXo+ei1JKaxQv8p85iEGkP158iWvOLiGBw0= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PN2PR01MB9027 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MAZPR01MB6815114742553C2273A15F82FCE22MAZPR01MB6815INDP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, * Is that multi master replication is not recommended to do ? * If we can do, can I get any resource for implementing that on PostgreSQL wh= ich is open-source? Thanks, Vidyshree H S ________________________________ From: Vidyashree H S Sent: Friday, May 10, 2024 10:48 AM To: Bruce Momjian ; Greg Sabino Mullane Cc: Kashif Zeeshan ; pgsql-general@lists.postgresq= l.org Subject: Re: Postgresql active-active nodes in cluster Thanks all for your inputs. * Currently I'm working on active-passive(Primary and standby scenario). * I'm preparing one study report on active-active node implementation which t= alks about active-active nodes background, theoretical explanation, impleme= ntation part which includes some trails on this. For that, I'm checking for= the resources. Thanks Vidyashree H S ________________________________ From: Bruce Momjian Sent: Friday, May 10, 2024 4:53 AM To: Greg Sabino Mullane Cc: Kashif Zeeshan ; Vidyashree H S ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql active-active nodes in cluster On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote: > > https://wiki.postgresql.org/wiki/Multimaster > > > That is a pretty old page. There are other solutions, such as pgedge, but= the > three most important questions when it comes to active-active replication= are: > > * Do you really, really need it? (hint: the answer is no) > * What problem are you trying to solve? > * Are you really willing to suffer the tradeoffs? Agreed, see this: https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018 -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. [EXT] --_000_MAZPR01MB6815114742553C2273A15F82FCE22MAZPR01MB6815INDP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,

  • Is that multi master replication is not recommended to do ?
  • If we can do, can I get any resource for implementing that on PostgreSQL wh= ich is open-source?



Thanks,
Vidyshree H S



From: Vidyas= hree H S <Shreevidya.hs@exaleapsemi.com>
Sent: Friday, May 10, 2024 10:48 AM
To: Bruce Momjian <bruce@momjian.us>; Greg Sabino Mullane= <htamfids@gmail.com>
Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; pgsql-gener= al@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster
 
Thanks all for your inputs.

  • Currently I'm working on active-passive(Primary and standby scenario).
  • I'm preparing one study report on active-active node implementation which t= alks about active-active nodes background, theoretical explanation, impleme= ntation part which includes some trails on this. For that, I'm checking for= the resources. 



Thanks
Vidyashree H S
From: Bruc= e Momjian <bruce@momjian.us>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; Vidyashree = H S <Shreevidya.hs@exaleapsemi.com>; pgsql-general@lists.postgresql.o= rg <pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster
 
On Thu, May  9, 2024 a= t 06:33:39PM -0400, Greg Sabino Mullane wrote:
>
>     https://wiki.postgresql.org/wiki/Multimaster
>
>
> That is a pretty old page. There are other solutions, such as pgedge, = but the
> three most important questions when it comes to active-active replicat= ion are:
>
> * Do you really, really need it? (hint: the answer is no)
> * What problem are you trying to solve?
> * Are you really willing to suffer the tradeoffs?

Agreed, see this:

        https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018

--
  Bruce Momjian  <bruce@momjian.us>    =     https://momjian.us
  EDB           = ;            &n= bsp;            = ;  https://enterprisedb.com

  Only you can decide what is important to you.
[EXT]
--_000_MAZPR01MB6815114742553C2273A15F82FCE22MAZPR01MB6815INDP_--