On Wed, Jun 8, 2011 at 3:59 AM, A J <s5aly@xxxxxxxxx> wrote: > 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. If the standby is completely sync with the master when failover happens, and if those two servers share the archive area, you can start new standby without taking a fresh base backup. You can do that by setting recovery_target_timeline to 'latest' in the recovery.conf and just starting new standby. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin