<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p></p>
<p style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
Thank you all for the answers. We'll proceed with this approach most likely. </p>
<br style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 13.3333px;">> If you're using Slony, you might as well go to 9.6.latest while
you're</span><br style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 13.3333px;">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 13.3333px;">at it.</span><span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"></span>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-size: 13.3333px;"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-size: 13.3333px;">Unfortunately, we won't be able to upgrade straight away. We have to take this environment one step at the time. </span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-size: 13.3333px;">Though, now that you mentioned data loss bugs we might speed it up and look into specifics more.</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-size: 13.3333px;"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-size: 13.3333px;">Thanks again!</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 13.3333px;">Zarko <br>
</span><span style="font-family: Calibri, Arial, Helvetica, sans-serif;"></span>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;"></div>
</div>
<div><br>
</div>
<p></p>
<div style="color: rgb(0, 0, 0);">
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> slony1-general-bounces@lists.slony.info <slony1-general-bounces@lists.slony.info> on behalf of David Fetter <david@fetter.org><br>
<b>Sent:</b> Thursday, February 23, 2017 7:00 PM<br>
<b>To:</b> slony1-general@lists.slony.info<br>
<b>Subject:</b> Re: [Slony1-general] Slony and streaming replication combo</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">On Wed, Feb 22, 2017 at 05:30:43PM +0000, Zarko Aleksic wrote:<br>
> Greetings everyone,<br>
> <br>
> We've recently started considering Slony for purpose of migrating<br>
> PostgreSQL from old physical server to a new virtualized and<br>
> "updated" platform. So far, all our tests worked quite well.<br>
> However, I'm having trouble finding any documentation to prove or<br>
> disprove that the following scenario is supported and/or will work<br>
> properly (initial testing was positive though).<br>
<br>
> "New B" (disaster recovery site) <---- Streaming replication ---- "New A" <--------Slony replication ----- "Old A" ------ existing SR ------> "Old B" (DR site)<br>
<br>
I can see no reason it wouldn't work. Slony does things that are<br>
pretty much disjoint from what streaming replication does, so they<br>
won't be able to ste on each others' toes.<br>
<br>
> We are using slony1-91-II-2.1.4 and Postgres 9.1 on RHEL 6, later we<br>
> will most likely do the same type of migration from 9.1 to 9.5.<br>
<br>
If you're using Slony, you might as well go to 9.6.latest while you're<br>
at it. You won't save time by replicating yet again to another<br>
virtual server, and the chances that going to 9.6 will break something<br>
are much smaller than the chances that staying on the now-defunct 9.1<br>
will. There have already been data loss bugs that were fixed since<br>
9.1 went out of support, i.e. 9.1 didn't get those fixes applied.<br>
<br>
That setup will work nicely with what I hope will become a routine<br>
operation, namely upgrading major versions. :)<br>
<br>
Best,<br>
David.<br>
-- <br>
David Fetter <david(at)fetter(dot)org> <a href="http://fetter.org/" id="LPlnk708103" previewremoved="true">
http://fetter.org/</a>
<div id="LPBorder_GT_14879764779180.4233275665991172" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;">
<table id="LPContainer_14879764779060.03733882289868573" cellspacing="0" style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);">
<tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_14879764779090.11910086233741857" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;">
<div id="LPRemovePreviewContainer_14879764779090.8633692516298448"></div>
<div id="LPTitle_14879764779090.7228387321693641" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;">
<a id="LPUrlAnchor_14879764779100.9488269188911436" href="http://fetter.org/" target="_blank" style="text-decoration: none;">David Fetter's Resume</a></div>
<div id="LPMetadata_14879764779110.7372928222632325" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;">
fetter.org</div>
<div id="LPDescription_14879764779160.16503764760035589" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;">
DAVID FETTER. 3250 West St Oakland, CA 94608-4330 phone: 415-235-3778 e-mail: david@fetter.org TripIt Calendar Feed. Computer Skills. Database Development and ...</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter<br>
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com<br>
<br>
Remember to vote!<br>
Consider donating to Postgres: <a href="http://www.postgresql.org/about/donate" id="LPlnk491096" previewremoved="true">
http://www.postgresql.org/about/donate</a><br>
_______________________________________________<br>
Slony1-general mailing list<br>
Slony1-general@lists.slony.info<br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" id="LPlnk971724">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
</div>
</span></font></div>
</div>
</body>
</html>