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

On 9/19/13, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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.

Of course, before you do anything, you should spend some time figuring
out WHY the old master failed. There could be issues that need to be
resolved before putting it back online, and fixing them could affect
how much work you have to do to get the physical files back in sync.
--
Mike Nolan