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 1s5V8P-005h36-N1 for pgsql-general@arkaria.postgresql.org; Fri, 10 May 2024 18:38:22 +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 1s5V8N-000P0u-24 for pgsql-general@arkaria.postgresql.org; Fri, 10 May 2024 18:38:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s5Iei-00CaXe-OU for pgsql-general@lists.postgresql.org; Fri, 10 May 2024 05:18:53 +0000 Received: from mail-centralindiaazon11021011.outbound.protection.outlook.com ([52.101.225.11] helo=PNZPR01CU001.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s5Iee-000IXW-Os for pgsql-general@lists.postgresql.org; Fri, 10 May 2024 05:18:51 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Yraa8Cabprk+vWJkXvL5v/U0MW3oPJzOPMli8iJHkX2nxa7Azpf7mjxxV656ognwcqrPZ7JJ0L8MfUBop91npBYoXowBr4mmes0BGthH/E+jY3FLzMDVSM+lPYFNyToaUNinFK66vWbfi4GEP8yvSyIbdsPPEiTlUnUzdv/eTMSRJZaGkoknmyETx+gi1TxELBPAv7NM7fFpYO0URUstrl515Pv84SYwnFrITSG+gJ4FjqB6aeqr7Jt505pmJ5OCAl67l0zLNPH7dtSpPNoLH5EnlGSL6EA/5LucYCStEBO8JGyiDKF6dnYHcnIZMslCcS+RS6Drgmrd3VbodrSQTA== 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=h7+m7osD0MEhINMeSZ5MU+d83k9mN7f+Rc9QOIavh3I=; b=NCYm6tXrHUdmenuKwwLqMAs5vHOooF1vGGNjnDY9Vu2I1XvFEG7dMDe9X0qhJMrIOF+8s49w+lgdIc0sw+d4bP7rSaL6MkI0h4lm05LT42hOJoIiuCUpcfiO5owVaei/O2k7AD987RHnuASk9qctKyqDO/UQo1gp6LDn5Gje8HLxKeq67+hL1eFMnNtKmULnKkKpJDUn+UCaVK8XO/GO4oH64unerJImqVPt0N7OMeTWDhwleyCAgfy/KBc/DhTPWCIINQ7idbJrkIDjuIJ7qxwAAYhZQCcfUn9+VhnziJtkB0atdbHBOrIEi9JR7LDxcjmW4nPM2T6/1Sw48QAKbg== 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=h7+m7osD0MEhINMeSZ5MU+d83k9mN7f+Rc9QOIavh3I=; b=eFOkT4L11FJ2noQw5oTJ2hNGnpCDXcm6/RikS5NH0Qua3ESyhUiW+m8IINYCoKclCl5DxUZ9RQxXuPRgoDlXGoyuU5F0PZ0MrR56UiYkTqrYknJ+Zn5RHDntEocH8+YW+xqZvERJqYXZqnSh0a/CVoGXlz73BacS1RlMe3jTVHY= Received: from MAZPR01MB6815.INDPRD01.PROD.OUTLOOK.COM (2603:1096:a01:56::8) by PN0PR01MB8648.INDPRD01.PROD.OUTLOOK.COM (2603:1096:c01:e3::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7544.47; Fri, 10 May 2024 05:18:42 +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.048; Fri, 10 May 2024 05:18:42 +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/sZ2LGOvAUAgADCIYCAAA3SgIAAYZQX Date: Fri, 10 May 2024 05:18:42 +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_|PN0PR01MB8648:EE_ x-ms-office365-filtering-correlation-id: 7cc1aac9-f6cd-4ca0-9ae6-08dc70b0a89d x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|1800799015|366007|376005|38070700009; x-microsoft-antispam-message-info: =?us-ascii?Q?NZoyWuN/PLyZAjWYlNZEzbUbUia1MAfYdIdOUGs38MoctHlVQZCTUQSqFgtf?= =?us-ascii?Q?92FvN6Mx2zSlFTIfJalAHPDJwrGT1hHAwEBN4ULmaLrxwtWcscXAZ+U/UAM1?= =?us-ascii?Q?R9TR4LsGFRoiZGel+g0dE+SBPxU+JRQIS2x6MxU/0HeF+8hEiNSfxzdJtktn?= =?us-ascii?Q?LMhbP8QHFG8HKB54fTWxaA6pgV86E4xOI0Iuackr3EziLenFQ+hW/CrdAywg?= =?us-ascii?Q?RIhGFoF8xMgDjUJagJaE13KSn37kQNXX6Ih4tM3VC5vaNYes8v4EurezhpSI?= =?us-ascii?Q?jntRyltRvHRtGZMulOw0gH/Nc7c5IAL0bSSrfT3lo53raLMlOdcvobcmmG/j?= =?us-ascii?Q?wxwAL6wD/zzACFTzB5D0tZ1Nooucx6wlAVoHPrRBtoq9Ea+4CjxUkgVndO7l?= =?us-ascii?Q?GwdCloslCreNQBldaqdX2feJpHczzNmNzjhbYThAITi8Qu0oqm3MLwGYI1Xz?= =?us-ascii?Q?zYAF+YRcD1YTTQnj84Q6e3seEK0PURfVAHBVy5yeTIXtKwaWDT5jHC2XTK86?= =?us-ascii?Q?AMu92T8eyRSLaeyLNxS/5Did8+z6m1u1hM7DimoS3f3uIGEjlg7V45/dp75A?= =?us-ascii?Q?Q0mwXpl8wkuK7q4NFqTXdveFP+plq89jEj9WpjwcxFY5keNOrUWxAztroZXO?= =?us-ascii?Q?gjKzJhPkeCdHAU2doDz52OaXBVxrZsA9/89HjlhewGcr+ASYUWGwBbNseAO3?= =?us-ascii?Q?ZqPTGlBtodU8S+vJak3nubUE0eDHhRIbpjVU7OJudHHL8DAhVajiMfSsF2Sp?= =?us-ascii?Q?R0mOaOOxkfHrmkTiJRcGu/4VhkdztH7O1rBRzFzgaqI5T1BthrBLFoIEm2re?= =?us-ascii?Q?GyVdIWRwAhYJtQRO+YuTPQfsyMOLNU9+7nNfM0FLKkkrbLTXD3R0RQ3Le8k9?= =?us-ascii?Q?gKo+09Vv+kGYfsTvfFRVCvKLoyvz8nevJKM/6wczXbqVSXij8atcsTR0IPGh?= =?us-ascii?Q?z9bQpcgAZrXlS9nMweWKCiYFFvS22o4d9eGPK/D5+UWs7l8CTsK8TJIUf5Vj?= =?us-ascii?Q?sT5+qCU7E92WJkH14AauErWZPWK5LO7S2LisNpJwwzCfYbXxouaZZp3r6LGD?= =?us-ascii?Q?3257wRvKdF/4jgTnPkcJGwPMXxJLJFoCpkh/SZ2xwCNL4ApwfdB5LPdns7PI?= =?us-ascii?Q?Jhk+FXWceC2v4J4v0IGCAa4BU2pbcHid/jWYFuV8Uwh0jBZwqa523sPOuv95?= =?us-ascii?Q?qrznNfXD7gdeZmzOUdeQih8rSZAFuS/mm20w+k7kfH7c2vJCYWJa8dBHt+S7?= =?us-ascii?Q?sz5EgEFO15uk+Lw4tfWbOXeSUZfNcLzbrvvzLR2xbw=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)(1800799015)(366007)(376005)(38070700009);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?e1x+t1of1h5D/nhYkoBvWkdsctKlCWAYC/NjEWh/5TPGcXB8j61agPEIuAzb?= =?us-ascii?Q?hl8YpsRY91fY+OCFdevazzKMyCyKL/DZ4uDQqwTUJ7/2Kyl/gNRL8GFYmvss?= =?us-ascii?Q?W6iKXlwwLMGlRMbJiUlhNn5y+uglbz50yxKMEw3zUe4ZWDDDoyCjzRCxYLW2?= =?us-ascii?Q?XsOw/+jM1KPbonOz9Rcnf7XUflALrDSd8tY1cjIwHQGlvql752UjLWHHQThV?= =?us-ascii?Q?V9l6iSeoRsHK0vN6CishMy986nXRkqVziUf3kL8V8dO1y/AGuXqos5SichlQ?= =?us-ascii?Q?yC1eHugpWiBPNIVVNN6/Ca/kAndHCURaDTlsRAd6nh3rhcFBo1My6U0ap+1P?= =?us-ascii?Q?w9HDkQvl7uppcVvfSj1dsEQ0viQ7QtEMpLMBGvZ1FRd2oCsh4isjlbiFd7xf?= =?us-ascii?Q?qFRxMLU1ID/PfaoeNIoTrZNs0qJqfMx3lkYKof6PFjb82yj+fy9bosjLeyB1?= =?us-ascii?Q?7BEDJ34mNtaFOyclULJ1/7Cba/dQhu5PkVVpRnagvdwk91xzE+IqO7vildp0?= =?us-ascii?Q?Q5idMamyF45uus4Uq67QGRHpIwlJFGlLRcLs6lZz5FerokyHhmsa8nHC+l9G?= =?us-ascii?Q?wLocykqw3mOsaR0gnhTn5uptm/c+jnhEBp6WSCriBJ6pkv5zTNrsG71fw8y6?= =?us-ascii?Q?FYV6g1p2/rbi6TLK4Tx8ArmT5GZfVT4r+tpahXPEM09fX97vvjnZ+jlfS47q?= =?us-ascii?Q?yHHdHO9tCfn4j0SItqJE1r86u6DqSrgEtJFEZeWcn7rXm8d02f8sCOdWiZCr?= =?us-ascii?Q?iLWTXKC61IIcivhBeH4ILYZ90zrolbLkFR1q0oKxgAcW/eq5VstJ7shIePL2?= =?us-ascii?Q?HT7cLC7a/qCg1pqS3MEBGQ39DJIcH3t0goENwP9xSTAK1ue4ffou0KhKkopd?= =?us-ascii?Q?nUAaWgt3Jl9YpkjuYc/wdJNjsBXhxN/wSpTG3Bq0KsmOM5cHIAd4TzhyIWz1?= =?us-ascii?Q?989JBH9jafAdO8/l2VZyyBz4YhyssifzoqzZLCLoYWoas+ItQkW4KKogrgDi?= =?us-ascii?Q?Wjq7+MgLws/YOMKUEBt4qkJOHP0Fs3M57pOrKsplnxw4H0lklLx1OWDTQQta?= =?us-ascii?Q?oRH6WohSdnOUtgvsSJ6Vwec7Z3LLFDXQKrboL/pX+xQGn6giyvrc7WLbVgFR?= =?us-ascii?Q?mavooJsqfjpL2cN0SVE6H8S8Q0XtzWhUW5rKpDL4Wpi3U6Sx5PNtKCZf3myL?= =?us-ascii?Q?fwvhiCd0qnVM2JW2/l0Lb/s+aeHQxHkvAYlXIUzPho6huhkU+qMFOJTyC5iI?= =?us-ascii?Q?VlfBmskTGQUi0oC3PNTSpqAtTEuwl6W/K8PjF67Cvb42WyQPOXgebfFcDpcS?= =?us-ascii?Q?LvDMx8CBwQEOUpfLsfhPL23+PT/jkUSaR4aQkZT7JJFxjAnzOWPx2uzfLsqE?= =?us-ascii?Q?+gYjac27Ah8Tn6XzeYylekURcoGzWUPWHrblpbt573AYeU0xnDJ6DWsOHz4S?= =?us-ascii?Q?AU9a8SMW011h1w4pFd0zVqf+4nsuiYHIV2zh+UJkAHSpGBRNX4+bMvDGLXtW?= =?us-ascii?Q?a2zvEEpA7V9dbeIVooUYM0D5xpmJzrFcBdc2UuJQfFO6VmQY4K28q4MkRsoG?= =?us-ascii?Q?X7ADBd7TaLbdue+OfY+ZTawyoCDJw6H7TZEJ55Duas38lgmh0Geujuxr6+pi?= =?us-ascii?Q?7Q=3D=3D?= Content-Type: multipart/alternative; boundary="_000_MAZPR01MB6815C3A83150D63752AB013AFCE72MAZPR01MB6815INDP_" 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: 7cc1aac9-f6cd-4ca0-9ae6-08dc70b0a89d X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2024 05:18:42.4696 (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: 8A1e2J3GuC7OuPJ0yKUO/LD4THZ2PwQOqzXsUNMCj0xsJ4P5NUZl+dhE7zx7sg8By4hsMOQ6JFe4TcavhsdtiihHlK3xYPTjzdqGCWxAW/k= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PN0PR01MB8648 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MAZPR01MB6815C3A83150D63752AB013AFCE72MAZPR01MB6815INDP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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_MAZPR01MB6815C3A83150D63752AB013AFCE72MAZPR01MB6815INDP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
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 <bru= ce@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 &= lt;Shreevidya.hs@exaleapsemi.com>; pgsql-general@lists.postgresql.org &l= t;pgsql-general@lists.postgresql.org>
Subject: Re: Postgresql active-active nodes in cluster
 
On Thu, May  9, 2024 at 06:33:39PM -0400, Gre= g 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_MAZPR01MB6815C3A83150D63752AB013AFCE72MAZPR01MB6815INDP_--