DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=xgCvPdp7K9ndkOK1x48+GLGOrl0rbPIs0cIDZ26JqVRiBgcSfS5pyLaem05w7x419RS+zBUCfJN1+2eoSl8qJcHZhiaiRlKHVIBwHxboqH8n9kwrfzM69xauHcqp6c5wFlLB2Yl5LnybiKSc+l3X9lZF+ZFF7IdZzXf0NZ2ycIM=;
Message-ID: <349220.32155.qm@web120008.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>
	<4DEE2B49020000250003E2A2@gw.wicourts.gov>
Date: Tue, 7 Jun 2011 11:59:07 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: Re: Switchover of Master and Slave roles
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
 Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <4DEE2B49020000250003E2A2@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-314295098-1307473147=:32155"

--0-314295098-1307473147=:32155
Content-Type: text/plain; charset=us-ascii

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

A J <s5aly@yahoo.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

--0-314295098-1307473147=:32155
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div>Ok. So if I understand it correctly, as far as Postgres is concerned the 'mirror is broken'. It is a one-time cutover.</div><div>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.</div><div>Right ?</div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Kevin Grittner &lt;Kevin.Grittner@wicourts.gov&gt;<br><b><span style="font-weight: bold;">To:</span></b> Ray Stell &lt;stellr@cns.vt.edu&gt;; A J &lt;s5aly@yahoo.com&gt;<br><b><span style="font-weight: bold;">Cc:</span></b>
 pgsql-admin@postgresql.org<br><b><span style="font-weight: bold;">Sent:</span></b> Tue, June 7, 2011 2:44:41 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [ADMIN] Switchover of Master and Slave roles<br></font><br>
A J &lt;<a ymailto="mailto:s5aly@yahoo.com" href="mailto:s5aly@yahoo.com">s5aly@yahoo.com</a>&gt; wrote:<br> <br>&gt; What does it exactly mean to 'recreate a standby server' ? Can I<br>&gt; not use the datafiles on the former primary and just let it sync<br>&gt; and get the incremental from the new primary ? Do I have to remove<br>&gt; all the data files from the former primary and get all the<br>&gt; datafiles through rsync (or other similar manner) from the new<br>&gt; primary ?<br> <br>The old server will probably be close enough that judicious use of<br>rsync with the old copy as the target will allow a base backup to be<br>taken very quickly.<br> <br>-Kevin<br></div></div><div style="position:fixed"></div>


</div></body></html>
--0-314295098-1307473147=:32155--