Re: Switchover of Master and Slave roles

Ok. So if I understand it correctly, as far as Postgres is concerned the 'mirror
is broken'. It is a one-time cutover.
We then rely on filesystem tools (or other third party tools) to get the
original master in sync with the new master efficiently and then make it join as
slave.
Right ?

________________________________
From: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>; A J <s5aly(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Sent: Tue, June 7, 2011 2:44:41 PM
Subject: Re: [ADMIN] Switchover of Master and Slave roles

A J <s5aly(at)yahoo(dot)com> wrote:

> What does it exactly mean to 'recreate a standby server' ? Can I
> not use the datafiles on the former primary and just let it sync
> and get the incremental from the new primary ? Do I have to remove
> all the data files from the former primary and get all the
> datafiles through rsync (or other similar manner) from the new
> primary ?

The old server will probably be close enough that judicious use of
rsync with the old copy as the target will allow a base backup to be
taken very quickly.

-Kevin