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@xxxxxxxxx> wrote: > On Thu, Sep 19, 2013 at 11:31 AM, ascot.moss@xxxxxxxxx > <ascot.moss@xxxxxxxxx >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
