Skip site navigation (1) Skip section navigation (2)

Re: Switchover of Master and Slave roles

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: A J <s5aly(at)yahoo(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Switchover of Master and Slave roles
Date: 2011-06-07 19:46:47
Message-ID: BANLkTinEcZbDJjqr_cV-ku5z8PUFgKnPRQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Jun 7, 2011 at 8:41 PM, Ray Stell <stellr(at)cns(dot)vt(dot)edu> wrote:
> On Tue, Jun 07, 2011 at 11:59:07AM -0700, A J wrote:
>> We then rely on filesystem tools (or other third party tools) to get the
>> original master in sync with the new master efficiently and then make it join as
>> slave.
>
> the doc would not be corrupted by an additional few words that stated as such:
>
> "To return to normal operation, a standby server must be recreated using
> external tools such as rsync, either on the former primary system when
> it comes up, or on a third, possibly new, system."

You need repmgr: http://www.repmgr.org/

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

pgsql-admin by date

Next:From: A JDate: 2011-06-07 21:33:53
Subject: Sync replication waits for only 1 slave
Previous:From: Ray StellDate: 2011-06-07 19:41:39
Subject: Re: Switchover of Master and Slave roles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group