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

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

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

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

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,

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

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