Postgres Pro
Downloads
Home   >   mailing lists

Re: How to failover from Primary to Standby and Set the old Primary as a new Standby - Mailing list pgsql-general

From Vick Khera
Subject Re: How to failover from Primary to Standby and Set the old Primary as a new Standby
Date
Msg-id CALd+dcetD=9mv2JO10gmkE6J0M8nB_u32CpjnkTJjM7NbneaPg@mail.gmail.com
Whole thread Raw
In response to How to failover from Primary to Standby and Set the old Primary as a new Standby  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Responses Re: How to failover from Primary to Standby and Set the old Primary as a new Standby  (John R Pierce <pierce@hogranch.com>)
Re: How to failover from Primary to Standby and Set the old Primary as a new Standby  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
Tree view

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.

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Upgrading from postgreSQL 9.1.6 to 9.3
Next
From: John R Pierce
Date:
Subject: Re: How to failover from Primary to Standby and Set the old Primary as a new Standby