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 1s5D6a-003y5r-Dp for pgsql-general@arkaria.postgresql.org; Thu, 09 May 2024 23:23:16 +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 1s5D6Y-00BRXK-Ey for pgsql-general@arkaria.postgresql.org; Thu, 09 May 2024 23:23:14 +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 1s5D6X-00BRXC-VM for pgsql-general@lists.postgresql.org; Thu, 09 May 2024 23:23:14 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s5D6U-000G4e-TU for pgsql-general@lists.postgresql.org; Thu, 09 May 2024 23:23:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2024011501; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=o+p1L/cgoZkljsbAMiKaGminsFhOLrBqPdwVliJgygE=; b=NlekZ 6g434oAwEgr1rcwRaBJTrdE8XBOwsRGMDX/QdsxJEDqqIe7Lnkfu5Rchvip6MnpDSee/muyckxftl h3l3mW8p21eLJ6NiSjH0hO5NOxKY5nbM1+dApey40zCSKyDa1NNt2i9vu9gTJTbhQ6FYxgYOnNYds ikV1dz2NzrekheW+oCT2Q1qkDUGvvp5uFnEtZDUcTBfSZBFRK203Pmq68UinmL0gnUcuBJ2lA5+g6 pDtoNs4hdFOOgWB6k7yyyEwkMRgEe4y+MCUlKD6iR0vwKHHe2RCgpGul+mS/wV0LcBlpJHxzMB66Q cY5lxy3v7NBvJdb/UWFqsGNi1wVyQ==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1s5D6R-006yxu-0z; Thu, 09 May 2024 19:23:07 -0400 Date: Thu, 9 May 2024 19:23:07 -0400 From: Bruce Momjian To: Greg Sabino Mullane Cc: Kashif Zeeshan , Vidyashree H S , "pgsql-general@lists.postgresql.org" Subject: Re: Postgresql active-active nodes in cluster Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.