Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Christophe Pettus
> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > > • 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 > u

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Achilleas Mantzios
Στις 15/7/24 22:55, ο/η Ron Johnson έγραψε: On Mon, Jul 15, 2024 at 3:28 PM Christophe Pettus wrote: > On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > [snip] >   • In the Community edition of PostgreSQL is it possible to setup  a cluster where all the nodes are ab

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Ron Johnson
On Mon, Jul 15, 2024 at 5:54 PM Christoph Moench-Tegeder wrote: > ## Ron Johnson (ronljohnso...@gmail.com): > > > This "lack of products" puzzles me, because DEC was doing this with VAX > > (then Alpha and Itanium) clusters 40 years ago via a Distributed Lock > > Manager integrated deep into VMS.

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Christoph Moench-Tegeder
## Ron Johnson (ronljohnso...@gmail.com): > This "lack of products" puzzles me, because DEC was doing this with VAX > (then Alpha and Itanium) clusters 40 years ago via a Distributed Lock > Manager integrated deep into VMS. Their Rdb and (CODASYL) DBMS products Tech and trade-offs have changed o

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Ron Johnson
On Mon, Jul 15, 2024 at 3:28 PM Christophe Pettus wrote: > > > On Jul 15, 2024, at 12:06, Sarkar, Subhadeep > wrote: > > > [snip] > > • 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

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread Christophe Pettus
> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > > • 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 >

Re: PostgreSQL Active-Active Clustering

2024-07-15 Thread David G. Johnston
On Mon, Jul 15, 2024 at 12:06 PM Sarkar, Subhadeep 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 >a