<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">I've done this. It works fine.</div><div class=""><br class=""></div><div class="">Make sure you install the slony extensions on Old B and New B in the event you need to fail over to one of the B nodes.</div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On Feb 22, 2017, at 6:52 PM, Steve Singer <<a href="mailto:steve@ssinger.info" class="">steve@ssinger.info</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class="">I can't think why it wouldn't work. You should be able to do streaming replication from a slony subscriber.<br class=""><br class="">I have not tried a similar setup myself<br class=""><br class="">Zarko Aleksic wrote:</div><blockquote cite="mid:BN3PR0401MB1560F28C4F5B0CC0EC8920069A500@BN3PR0401MB1560.namprd04.prod.outlook.com" type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; font-family: Calibri, Arial, Helvetica, sans-serif;" class=""><div style="margin-top: 0px; margin-bottom: 0px;" class="">Greetings everyone,</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><p style="margin-top: 0px; margin-bottom: 0px;" class=""></p><div style="margin-top: 0px; margin-bottom: 0px;" class=""><span class="">We've recently started considering Slony for purpose of migrating PostgreSQL from old physical server to a new virtualized and </span><span class="">"updated" platform. So far, all our tests worked quite well. However, I</span>'m having trouble finding any documentation to prove or disprove that the following scenario is supported and/or will work properly (initial testing was positive though).</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><p style="margin-top: 0px; margin-bottom: 0px;" class=""></p><div style="margin-top: 0px; margin-bottom: 0px;" class=""><span style="font-size: 12pt;" class="">We would like to setup streaming replication between future Slony subscriber and our DR site beforehand, ie. <span class="">before we introduce Slony</span>. This would save us time and additional work post migration. </span></div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">It would look something like this:</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><span class=""><span class=""><span style="background-color: rgb(255, 255, 0);" class="">"New B" (disaster recovery site) </span><span class=""> <</span><span class="">---- Streaming replication ---- </span></span><span style="background-color: rgb(255, 255, 0);" class="">"New A</span>"<span class="Apple-converted-space"> </span><span class=""><--------Slony replication -----</span><span style="background-color: rgb(190, 190, 190);" class=""> </span></span><span style="background-color: rgb(190, 190, 190);" class="">"Old A" ------ existing SR ------> </span><span class="">"Old B" (</span><span class="">DR site</span><span class="">)</span></div><p style="margin-top: 0px; margin-bottom: 0px;" class=""></p><ul class=""><li class="">Streaming replication between "New A" and "New B"<span class="Apple-converted-space"> </span><u class="">would be setup first</u></li><li class="">Then we would setup Slony replication between "Old A" and "New A"</li><li class=""><span style="font-size: 12pt;" class="">Slony replication Set would be moved from "Old A" to "New A"</span></li><li class=""><span style="font-size: 12pt;" class="">Slon process would be stopped and Slony Schema would be removed </span><br class=""></li></ul><div class="">Has anyone done something similar? Are there potential downsides to this idea? </div><div class=""><br class=""></div><div class="">We are using <span class="">slony1-91-II-2.1.4 and Postgres 9.1 on RHEL 6, later we will most likely do the same type of migration from 9.1 to 9.5. </span></div><div class=""><span class=""><br class=""></span></div><div class="">Any response is greatly appreciated.</div><div class="">Thanks!</div><div class="">Zarko</div><p style="margin-top: 0px; margin-bottom: 0px;" class=""></p><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div></div></blockquote><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""></div><pre class="moz-signature" cols="72" style="font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);">Sent Using Firefox OS</pre><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); float: none; display: inline !important;" class="">Slony1-general mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><a href="mailto:Slony1-general@lists.slony.info" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class="">Slony1-general@lists.slony.info</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""><a href="http://lists.slony.info/mailman/listinfo/slony1-general" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class="">http://lists.slony.info/mailman/listinfo/slony1-general</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" class=""></div></blockquote></div><br class=""></body></html>