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

Re: Postgresql active-active nodes in cluster

2024-05-13 Thread Greg Sabino Mullane
On Mon, May 13, 2024 at 2:53 AM Vidyashree H S < shreevidya...@exaleapsemi.com> wrote: > >- Is that multi master replication is not recommended to do ? > > No, it is not recommended, as it has a very, very narrow use case, and comes with a lot of drawbacks. Sure, you COULD configure your car t

Re: Postgresql active-active nodes in cluster

2024-05-13 Thread Vidyashree H S
Momjian ; Greg Sabino Mullane Cc: Kashif Zeeshan ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql active-active nodes in cluster Thanks all for your inputs. * Currently I'm working on active-passive(Primary and standby scenario). * I'm preparing one study report

Re: Postgresql active-active nodes in cluster

2024-05-10 Thread Vidyashree H S
ludes some trails on this. For that, I'm checking for the resources. Thanks Vidyashree H S From: Bruce Momjian Sent: Friday, May 10, 2024 4:53 AM To: Greg Sabino Mullane Cc: Kashif Zeeshan ; Vidyashree H S ; pgsql-general@lists.postgresql.org Subject: Re: Po

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote: > > https://wiki.postgresql.org/wiki/Multimaster > > > That is a pretty old page. There are other solutions, such as pgedge, but the > three most important questions when it comes to active-active replication are: > > * Do

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Greg Sabino Mullane
> https://wiki.postgresql.org/wiki/Multimaster > That is a pretty old page. There are other solutions, such as pgedge, but the three most important questions when it comes to active-active replication are: * Do you really, really need it? (hint: the answer is no) * What problem are you trying to

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Kashif Zeeshan
Hi You can use BDR, you can have a look on the following link. https://wiki.postgresql.org/wiki/Multimaster Thanks Kashif Zeeshan Bitnine Global On Thu, May 9, 2024 at 3:28 PM Vidyashree H S wrote: > Hi, > > I'm using Postgresql 15.4 version on RISCV architecture > I'm trying to implement act

RE: PostgreSQL Active-Active

2018-02-07 Thread Alexander Kukushkin
a. m. Para: Dhandapani Shanmugam CC: pgsql-admin; pgsql-gene...@postgresql.org Asunto: Re: PostgreSQL Active-Active Greetings, * Dhandapani Shanmugam (postgresq...@gmail.com) wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question ha

RE: PostgreSQL Active-Active

2018-02-07 Thread Lazaro Garcia
-gene...@postgresql.org Asunto: Re: PostgreSQL Active-Active Greetings, * Dhandapani Shanmugam (postgresq...@gmail.com) wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question has been addressed already. What will be best > open sour

Re: PostgreSQL Active-Active

2018-02-06 Thread Shreeyansh Dba
You can achieve this HA with forward and backward reverse synchronous streaming replication with 3 nodes automatic failover with pgpool in PostgreSQL. There is always downtime but it should not be more than a minute its depends on your hardware and network bandwidth speed availability. -- [image

Re: PostgreSQL Active-Active

2018-02-06 Thread Laurenz Albe
Dhandapani Shanmugam wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question has been addressed already. > What will be best open source HA for postgresql with zero RTO and RPO. No, PostgreSQL does not have a shared storage cluster technology li

Re: PostgreSQL Active-Active

2018-02-06 Thread Stephen Frost
Greetings, * Andreas Kretschmer (andr...@a-kretschmer.de) wrote: > Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam: > >Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > >Sorry if this question has been addressed already. What will be best open > >source HA for postgr

Re: PostgreSQL Active-Active

2018-02-06 Thread Stephen Frost
Greetings, * Dhandapani Shanmugam (postgresq...@gmail.com) wrote: > Do we have active-active setup in postgreSQL, like we have in oracle RAC?. > Sorry if this question has been addressed already. What will be best open > source HA for postgresql with zero RTO and RPO. What you're probably looking

Re: PostgreSQL Active-Active

2018-02-06 Thread Andreas Kretschmer
Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam: Hi Gurus, Do we have active-active setup in postgreSQL, like we have in oracle RAC?. Sorry if this question has been addressed already. What will be best open source HA for postgresql with zero RTO and RPO. -D we have BDR, but this isn