Re: PostgreSQl HA solution - Mailing list pgsql-general

From Jehan-Guillaume de Rorthais
Subject Re: PostgreSQl HA solution
Date
Msg-id 20161130210814.75ce46b9@firost
Whole thread Raw
In response to Re: PostgreSQl HA solution  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Wed, 30 Nov 2016 08:58:13 -0800
"Joshua D. Drake" <jd@commandprompt.com> wrote:

> On 11/30/2016 06:00 AM, Marcin Giedz wrote:
> > Hello,
> >
> > Does anyone know any reliable open source HA solution with stream
> > replication and IP live migration in case of master node failure?
> > Recently I've been attending Fujitsu PostgreSQL webinar and they
> > presented so called "mirroring controler" + sync stream replication .
> > I'm wondering if this combines of regular stream replication + some kind
> > of keepalive mechanism ?
>
> LinuxHA/Pacemaker/Corosync can do this.

Just for the record, PAF is a new resource agent for such stack. It just
replaces the default "pgsql" RA delivered in the resource-agents package on
various distro.

Regards,


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: Monitoring Replication - Postgres 9.2
Next
From: George
Date:
Subject: Re: Index is not used for "IN (non-correlated subquery)"