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 1s5CMI-003tQd-6e for pgsql-general@arkaria.postgresql.org; Thu, 09 May 2024 22:35:26 +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 1s5CLH-00BCKV-IX for pgsql-general@arkaria.postgresql.org; Thu, 09 May 2024 22:34:23 +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 1s5CLH-00BCKN-7a for pgsql-general@lists.postgresql.org; Thu, 09 May 2024 22:34:23 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s5CLE-000F1V-DN for pgsql-general@lists.postgresql.org; Thu, 09 May 2024 22:34:22 +0000 Received: by mail-lf1-x12e.google.com with SMTP id 2adb3069b0e04-51f71e4970bso1672234e87.2 for ; Thu, 09 May 2024 15:34:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715294057; x=1715898857; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=VLIA32K0YNsm0U2Md8AzR9D3AF14733lM8CmrYPiJ+s=; b=CpLHYf3Nqrhugyex9mOOgcnxKhUfsKL08a/l6KvuzbcD7GD5Pxb02CXnDOYuhLRXTx 43VbQxcpo0RfHK5WynXaIQf3VzJtiZ1nLzsnRlj/G7PW37HDRtJdW/dmgH3XTbfvyFk6 xF9+kX3Zb9K8IzVVM5jEH28nX3pdHFUrdLhF1WYRWv7snBENwSBlA0UOJzkEgj0/Es4S 005L6p2CTc/jO38gvD5dDrhiEdWxVnMuIY7dIqjbnzKrK+DcoTdGEvBfiuiVzqSpqIhf v2a52q+0DH0RSMSk32MWVcODjz/4DFReNfY8DxQOJePaW+OMnBTj737xmDrTeer1QgCn /YdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715294057; x=1715898857; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=VLIA32K0YNsm0U2Md8AzR9D3AF14733lM8CmrYPiJ+s=; b=kKKPk9mv7RzVOpKEIP2uf4TLTApHnYYS80q0EsZ1q02FGPYzMQN/lGih1gNd9S465R PyY9+N+QfYxGOjT24UtWKKy2Y3AaGKqa+ufTi/d++WbOT+cTGGBN/otxgcbl+tfY/0ux tF2FIfRBJdGxmYfxP3BG0bfhmx/ENPE/5NcadHUmjaYKUGtn8jrm+dAIvu5qloh3b4DC 400hrfxVIe/PDrPCzjbFnikQc7kptIhhQDTx7sLboAzY9DD/erKzpiIX4aX64EV6pIsl mTvXbwhuncX8MnXiuQU8LH/y2hw0waxlWbAf7iY0v6obH/XrI7rT2zeQzA2agTZp1gZE 8GlQ== X-Forwarded-Encrypted: i=1; AJvYcCUTE2LcBoS5pnE0SLvS9E3rJg0oE9vm5c9UgHymDh9+PaSNtrCbzNitg/U6BnsoRbd1S/eZBXqahO5i4lIAjjQD8Dc+9JK2HU2+HvponDq0DuPe X-Gm-Message-State: AOJu0YzOSrqtjD7nDn2By4d4VISOOfRXET8rI5q7kkMVvjEtG3Vm7uNO iMXEjmjsQwlFhyCWwLSS9Zgw0+nY9W/bYJu+4ZCXMOcV4ZqqQ4Z+x/CzaZYX6HTRCVsI7DaiaMI ubAomMXlse3u+MD29viL5rEjMxj0= X-Google-Smtp-Source: AGHT+IGiglo5CkbAs9yUoZQuCPlUAei0BO9E+19eP1DABG4uy25LoSQVDfv0Srqyzp+7UgqCGyseoY6ikxvTI8rLJlI= X-Received: by 2002:a05:6512:281d:b0:51c:dc6:a1ce with SMTP id 2adb3069b0e04-5220fc6df92mr771307e87.7.1715294057072; Thu, 09 May 2024 15:34:17 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Thu, 9 May 2024 18:33:39 -0400 Message-ID: Subject: Re: Postgresql active-active nodes in cluster To: Kashif Zeeshan Cc: Vidyashree H S , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000f50f6706180d0486" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f50f6706180d0486 Content-Type: text/plain; charset="UTF-8" > 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? Cheers, Greg P.S. Please upgrade to v15.7 --000000000000f50f6706180d0486 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
That is a pretty old page. There are other solutions, such as pg= edge, 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?

=
Cheers,
Greg

P.S. Please upgr= ade to v15.7

--000000000000f50f6706180d0486--