On Mon, Jul 15, 2024 at 12:06 PM Sarkar, Subhadeep <subhadeepsar...@kpmg.com> wrote:
> > We are evaluating features of the Community edition of PostgreSQL in > relation to a proposal for a prospective client and need help with the > queries below:- > > > > - 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. > > Basically, no. See "logical replication" if you'd like to delve into why I qualified this one. > > - 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). > > No > - 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). > > > No There is only one server process per underlying data directory in PostgreSQL. David J.
