Re: Postgresql HA cluster

Hi Jason, On Tue, 17 Oct 2023 19:59:00 + Jason Grammenos wrote: [...] > If you have 2 PostgreSQL nodes hooked up to a Load balancer (haproxy), and > you move take node1 out of load balancing, you now have connections on node1 > and connections on node2, as the Load balancer drains the connec

RE: Postgresql HA cluster

: Jehan-Guillaume de Rorthais Sent: Friday, October 13, 2023 9:10 AM To: Jason Grammenos Cc: pgsql-general@lists.postgresql.org Subject: Re: Postgresql HA cluster On Fri, 13 Oct 2023 12:02:53 + Jason Grammenos wrote: > Thank you for the feedback, > > I have used pacemaker for ot

Re: Postgresql HA cluster

On Fri, 13 Oct 2023 19:21:46 + Laura Smith wrote: > --- Original Message --- > On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais > wrote: > > > But really, double check first why a simple primary-standby architecture > > doesn't meet your needs. The simpler the arc

Re: Postgresql HA cluster

--- Original Message --- On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais wrote: > But really, double check first why a simple primary-standby architecture > doesn't > meet your needs. The simpler the architecture is, the better. Even from the > application point of

Re: Postgresql HA cluster

On Fri, 13 Oct 2023 12:02:53 + Jason Grammenos wrote: > Thank you for the feedback, > > I have used pacemaker for other purposes previously so am a little familiar > with it. So you might be familiar with shared-storage cluster, that are the simpler one you could deploy (baring you have a

RE: Postgresql HA cluster

m/> Learn new PR tips from our free resources<https://www.agilitypr.com/resources/>. From: Олег Самойлов Sent: Thursday, October 12, 2023 11:08 AM To: Jason Grammenos ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql HA cluster For Postgresql HA cluster the most popular solution

Re: Postgresql HA cluster

For Postgresql HA cluster the most popular solution is streaming replication. There is an option how implement this. Web programmer approach is using haproxy+consul+patrony. The "old schoool" is using Pacemaker, all in one bottle and well tested. If you interesting how implement in Pace

Postgresql HA cluster

Hello, I am new to PostgreSQL and having to migrate a Cassandra cluster to PostgreSQL. Have a reasonable amount of experience with MySQL and use Master -> Master MySQL replication quite successfully. I am trying to understand what configuration/option to pick for PostgreSQL that will provide th

Re: PostgreSQL HA

Am 26.12.20 um 17:20 schrieb venkata786 k: Hi Ganesh, BDR supports postgres 12 & 13 versions ?? I think we have BDR compatible for 9.4 postgres. Could you plz confirm. That's true. PG 9.4 is out of support. Regards, Andreas -- 2ndQuadrant, an EDB company www.2ndQuadrant.com / www.enterp

Re: PostgreSQL HA

On Sat, 26 Dec 2020 05:51:22 +0530 venkata786 k wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing master-slave. Symmetric replication bring a lot of comp

Re: PostgreSQL HA

Hi Ganesh, I saw symmetric DS in Google. Are there any disadvantages with symmetric DS? Virus-free. www.avast.com

Re: PostgreSQL HA

Hi Ganesh, BDR supports postgres 12 & 13 versions ?? I think we have BDR compatible for 9.4 postgres. Could you plz confirm. On Sat, 26 Dec 2020 at 16:22, Ganesh Korde wrote: > You can go for BDR from 2nd Quadrant. > > On Sat, 26 Dec 2020, 4:17 pm venkata786 k, wrote: > >> Hi Team, >> >> Coul

Re: PostgreSQL HA

Use xdb, simpler and better On Saturday, December 26, 2020, venkata786 k wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Regards, >

Re: PostgreSQL HA

You can go for BDR from 2nd Quadrant. On Sat, 26 Dec 2020, 4:17 pm venkata786 k, wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Reg

PostgreSQL HA

Hi Team, Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions. My Team is thinking about implementing active-active replacing master-slave. Regards, Venkat

Re: Postgresql HA Cluster

Hi Albe, Here is my one more concern regarding patroni and repmgr tool versions compatibility with centos8 and postgresql 10/11/12 versions, could u plz provide ur valuable output. Thanks Brajendra On Mon, 29 Jun, 2020, 1:03 PM Laurenz Albe, wrote: > On Sun, 2020-06-28 at 09:10 +0530, Brajendr

Re: Postgresql HA Cluster

På mandag 29. juni 2020 kl. 09:40:13, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 29.06.20 um 09:33 schrieb Laurenz Albe: > That would not provode a multi-master solution, though. There are some > commercial solutions for that, but be warned that

Re: Postgresql HA Cluster

Am 29.06.20 um 09:33 schrieb Laurenz Albe: That would not provode a multi-master solution, though. There are some commercial solutions for that, but be warned that it would require non-trivial changes to your application. not really with BDR3 ;-) Andreas -- 2ndQuadrant - The PostgreSQL

Re: Postgresql HA Cluster

On Sun, 2020-06-28 at 09:10 +0530, Brajendra Pratap Singh wrote: > Is there any functionality present in postgresql for High Availability > Cluster where we can setup > multiple nodes/instances in READ-WRITE mode for single database so that > incase of one node/instance > failure it will automati

Fwd: BUG #16513: Postgresql HA Cluster

Hi Team, Please help us on the below query . Thanks -- Forwarded message - From: Daniel Gustafsson Date: Sat, 27 Jun, 2020, 3:16 AM Subject: Re: BUG #16513: Postgresql HA Cluster To: , PostgreSQL mailing lists < pgsql-b...@lists.postgresql.org> > On 26 Jun 2020, at

Postgresql HA Cluster

Hi All, Is there any functionality present in postgresql for High Availability Cluster where we can setup multiple nodes/instances in READ-WRITE mode for single database so that incase of one node/instance failure it will automatically failover the traffic to 2nd node/instance (without failure or

AW: PostgreSQL HA FO question

production experience. Von: Dor Ben Dov Gesendet: Montag, 9. Dezember 2019 13:24 An: Zwettler Markus (OIZ) ; pgsql-general@lists.postgresql.org Betreff: RE: PostgreSQL HA FO question Hi Zwettler, Based on what comparison, production experience ? Regards, Dor From: Zwettler Markus (OIZ

RE: PostgreSQL HA FO question

Hi Zwettler, Based on what comparison, production experience ? Regards, Dor From: Zwettler Markus (OIZ) Sent: Monday, December 9, 2019 1:13 PM To: Dor Ben Dov ; pgsql-general@lists.postgresql.org Subject: AW: PostgreSQL HA FO question In my opinion, the best open source product is Patroni

AW: PostgreSQL HA FO question

In my opinion, the best open source product is Patroni. Von: Dor Ben Dov Gesendet: Montag, 9. Dezember 2019 11:24 An: pgsql-general@lists.postgresql.org Betreff: PostgreSQL HA FO question Hi everyone, What is the best / mostly common / production used open source solution for HA / FO

PostgreSQL HA FO question

Hi everyone, What is the best / mostly common / production used open source solution for HA / FO/ backup and restore. Open source community / Commercial Best Regards, Dor Ben Dov This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Ter