Assuming the database hasn't changed much since the failover, doing a
fsync from the new primary back to the old primary should be fairly
quick.
--
Mike Nolan
On 9/19/13, Vick Khera <vivek@khera.org> wrote:
> On Thu, Sep 19, 2013 at 11:31 AM, ascot.moss@gmail.com
> <ascot.moss@gmail.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.
>
