Re: PostgreSQl HA solution

From: Jehan-Guillaume de Rorthais <ioguix(at)free(dot)fr>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQl HA solution
Date: 2016-11-30 20:08:14
Message-ID: 20161130210814.75ce46b9@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 30 Nov 2016 08:58:13 -0800
"Joshua D. Drake" <jd(at)commandprompt(dot)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,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George 2016-11-30 20:08:36 Re: Index is not used for "IN (non-correlated subquery)"
Previous Message Patrick B 2016-11-30 19:57:45 Re: Monitoring Replication - Postgres 9.2