Re: PostgreSQL Active-Active Clustering

On Mon, Jul 15, 2024 at 12:06 PM Sarkar, Subhadeep <subhadeepsarkar(at)kpmg(dot)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.