<html><body><body bgcolor="#FFFFFF" text="#000000"><div>I can't think why it wouldn't work. You should be able to do streaming replication from a slony subscriber.<br/><br/>I have not tried a similar setup myself<br/><br/>Zarko Aleksic wrote:</div><blockquote cite="mid:BN3PR0401MB1560F28C4F5B0CC0EC8920069A500@BN3PR0401MB1560.namprd04.prod.outlook.com" type="cite">
<style type="text/css" style="display:none;"> P {margin-top:0;;margin-bottom:0;;}</style>
<div id="divtagdefaultwrapper" style="font-size:12pt;;color:#000000;;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>Greetings everyone,</p>
<p><br/>
</p>
<p></p>
<p style="">
<span style="">We've recently started considering Slony for purpose of migrating PostgreSQL
from old physical server to a new virtualized and </span><span style="">"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).</p>
<p style="">
<br/>
</p>
<p></p>
<p><span style="font-size: 12pt;">We would like to setup streaming replication between future Slony subscriber and our DR site beforehand, ie. <span style="">before
we introduce Slony</span>. This would save us time and additional work post migration. </span></p>
<p><br/>
</p>
<p>It would look something like this:</p>
<p><span style=""><span style=""><span style="background-color: rgb(255, 255, 0);">"New
B" (disaster recovery site) </span><span style=""> <</span><span style="">----
Streaming replication ---- </span></span><span style="background-color: rgb(255, 255, 0);">"New A</span>"
<span style="">
<--------Slony replication -----</span><span style="background-color: rgb(190, 190, 190);"> </span></span><span style="background-color: rgb(190, 190, 190);">"Old A" ------ existing SR ------> </span><span style="">"Old
B" (</span><span style="">DR site</span><span style="">)</span></p>
<p></p>
<ul>
<li>Streaming replication between "New A" and "New B" <u>would be setup first</u></li><li>Then we would setup Slony replication between "Old A" and "New A"</li><li><span style="font-size: 12pt;">Slony replication Set would be moved from "Old A" to "New A"</span></li><li><span style="font-size: 12pt;">Slon process would be stopped and Slony Schema would be removed </span><br/>
</li></ul>
<div>Has anyone done something similar? Are there potential downsides to this idea? </div>
<div><br/>
</div>
<div>We are using <span>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><span><br/>
</span></div>
<div>Any response is greatly appreciated.</div>
<div>Thanks!</div>
<div>Zarko</div>
<p></p>
<p><br/>
</p>
</div>
</blockquote><div></div>
<pre class="moz-signature" cols="72">Sent Using Firefox OS</pre></body></html>