Re: How to failover from Primary to Standby and Set the old Primary as a new Standby

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to failover from Primary to Standby and Set the old Primary as a new Standby
Date: 2013-09-19 20:32:31
Message-ID: 523B5F5F.8080109@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/19/2013 1:29 PM, Vick Khera wrote:
>
> On Thu, Sep 19, 2013 at 11:31 AM, ascot(dot)moss(at)gmail(dot)com
> <mailto:ascot(dot)moss(at)gmail(dot)com> <ascot(dot)moss(at)gmail(dot)com
> <mailto:ascot(dot)moss(at)gmail(dot)com>> wrote:
>
> I use PG 9.2.4 with streaming replication. What will be the
> manual procedure to failover from Primary to Standby and Set the
> old Primary as a new standby?
>
>
> From what I understand, you start over by setting up the old primary
> as a new standby from scratch.

if you use rsync for the base backup of new master to old, it should go
fairly quickly as relatively few files should have changed assuming not
much time has elapsed.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2013-09-19 20:34:52 Re: How to failover from Primary to Standby and Set the old Primary as a new Standby
Previous Message Vick Khera 2013-09-19 20:29:03 Re: How to failover from Primary to Standby and Set the old Primary as a new Standby