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 <[email protected]> wrote: > On Thu, Sep 19, 2013 at 11:31 AM, [email protected] > <[email protected] >> 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. > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
