Re: PostgreSQL Active-Active Clustering - Mailing list pgsql-general

From Christophe Pettus
Subject Re: PostgreSQL Active-Active Clustering
Date
Msg-id 63D0944C-AD2C-4019-983E-416C764B3BDD@thebuild.com
Whole thread Raw
In response to PostgreSQL Active-Active Clustering  ("Sarkar, Subhadeep" <subhadeepsarkar@kpmg.com>)
List pgsql-general

> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep <subhadeepsarkar@kpmg.com> wrote:
>
>  • Does the Community edition of PostgreSQL provide NATIVE active-active high availability clustering with objectives
ofscalability, load balancing and high availability without using any extensions or external components or usage of
Kubernetes/Dockers. 
>
>  • In the Community edition of PostgreSQL is it possible to setup a database cluster in load balancing mode and
providevertical and horizontal scalability without repartitioning or changes to the database objects or 3rd party
transactionrouting mechanisms using NATIVE features only (i.e. without using any extensions or external components or
usageof Kubernetes/Dockers). 
>
>  • In the Community edition of PostgreSQL is it possible to setup  a cluster where all the nodes are able to
concurrentlyread-write the underlying database image using NATIVE features (i.e. without using any extensions or
externalcomponents 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
commercialdatabase vendor (in fact, a particular commercial database vendor) in order to exclude open-source software.
Open-sourcesoftware relies very much on a whole ecosystem, rather than attempting to deliver every imaginable feature
inthe core distribution.  This is especially true of projects like PostgreSQL which are not backed by a single company
anddo not have an official commercial distribution.  Can your client articulate why they need these specific features,
andwhy they must be in the core distribution? 


pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: PostgreSQL Active-Active Clustering
Next
From: "David G. Johnston"
Date:
Subject: Re: Dropping column from big table