Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5C994B5DC29 for ; Tue, 7 Jun 2011 15:40:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 40032-01-5 for ; Tue, 7 Jun 2011 18:40:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id AF1CCB5F54D for ; Tue, 7 Jun 2011 15:40:04 -0300 (ADT) Received: from [192.168.10.3] (ASte-Genev-Bois-153-1-40-45.w83-200.abo.wanadoo.fr [83.200.90.45]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 9B4CA3B8F5; Tue, 7 Jun 2011 20:40:03 +0200 (CEST) Subject: Re: Switchover of Master and Slave roles From: Guillaume Lelarge To: A J Cc: Ray Stell , pgsql-admin@postgresql.org Date: Tue, 07 Jun 2011 20:40:03 +0200 In-Reply-To: <264025.13168.qm@web120005.mail.ne1.yahoo.com> References: <693391.31715.qm@web120020.mail.ne1.yahoo.com> <20110607181244.GA3861@cns.vt.edu> <264025.13168.qm@web120005.mail.ne1.yahoo.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.0.2 (3.0.2-1.fc15) Content-Transfer-Encoding: 7bit Message-ID: <1307472003.2027.1.camel@laptop> Mime-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/33 X-Sequence-Number: 37659 On Tue, 2011-06-07 at 11:33 -0700, A J wrote: > >>To return to normal operation, a standby server must be recreated, > either on the former primary system when it comes up<< > > > 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 ? > > Don't remove them. This way, rsync will only send the changed files. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com