Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: PostgreSQL Active-Active Clustering
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <PN0PR01MB90693B1DF528D64769D81B91C5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
Date: Mon, 15 Jul 2024 22:38:46 -0700
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>,
 "Sur, Sanjay" <sanjaysur@kpmg.com>
Content-Transfer-Encoding: quoted-printable
Message-Id: <63D0944C-AD2C-4019-983E-416C764B3BDD@thebuild.com>
References: <PN0PR01MB9069922B90966633C8183C5AC5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
 <PN0PR01MB90693B1DF528D64769D81B91C5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
To: "Sarkar, Subhadeep" <subhadeepsarkar@kpmg.com>
Archived-At: <https://www.postgresql.org/message-id/63D0944C-AD2C-4019-983E-416C764B3BDD%40thebuild.com>
Precedence: bulk


> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep =
<subhadeepsarkar@kpmg.com> wrote:
>=20
>  =E2=80=A2 Does the Community edition of PostgreSQL provide NATIVE =
active-active high availability clustering with objectives of =
scalability, load balancing and high availability without using any =
extensions or external components or usage of Kubernetes/Dockers.=20
>=20
>  =E2=80=A2 In the Community edition of PostgreSQL is it possible to =
setup a database cluster in load balancing mode and provide vertical and =
horizontal scalability without repartitioning or changes to the database =
objects or 3rd party transaction routing mechanisms using NATIVE =
features only (i.e. without using any extensions or external components =
or usage of Kubernetes/Dockers).
>=20
>  =E2=80=A2 In the Community edition of PostgreSQL is it possible to =
setup  a cluster where all the nodes are able to concurrently read-write =
the underlying database image using NATIVE features (i.e. without using =
any extensions or external components or usage of Kubernetes/Dockers).

I do have to add that this list of requirements sounds very much like a =
set supplied by the sales organization of a commercial database vendor =
(in fact, a particular commercial database vendor) in order to exclude =
open-source software.  Open-source software relies very much on a whole =
ecosystem, rather than attempting to deliver every imaginable feature in =
the core distribution.  This is especially true of projects like =
PostgreSQL which are not backed by a single company and do not have an =
official commercial distribution.  Can your client articulate why they =
need these specific features, and why they must be in the core =
distribution?=