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 <vi...@khera.org> wrote: > On Thu, Sep 19, 2013 at 11:31 AM, ascot.m...@gmail.com > <ascot.m...@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. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
