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.Grittner@wicourts.gov> To: Ray Stell <stellr@cns.vt.edu>; A J <s5aly@yahoo.com> Cc: pgsql-admin@postgresql.org Sent: Tue, June 7, 2011 2:44:41 PM Subject: Re: [ADMIN] Switchover of Master and Slave roles
> 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.