| From: | Michael Nolan <htfoot(at)gmail(dot)com> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>, pgsql-general general <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:34:52 |
| Message-ID: | CAOzAquKF23qCOQE44+-kJd9EPE_PN7zk1YFe3FCoz3kdvkCxRA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)khera(dot)org> wrote:
> On Thu, Sep 19, 2013 at 11:31 AM, ascot(dot)moss(at)gmail(dot)com
> <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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Nolan | 2013-09-19 20:39:44 | Re: How to failover from Primary to Standby and Set the old Primary as a new Standby |
| Previous Message | John R Pierce | 2013-09-19 20:32:31 | Re: How to failover from Primary to Standby and Set the old Primary as a new Standby |