<div dir="ltr">You would need to install the new slony libs and upgrade slony, but yes it should work</div><div class="gmail_extra"><br><div class="gmail_quote">On 29 September 2015 at 17:23, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Good evening<br><br></div>Fairly simple question (I think) <br></div>Can I use the pg_upgrade contrib module to upgrade from postgres 9.2 to 9.4 without having to<br></div>re-define and re-subscribe all of the slony replicated data? My initial pg_upgrade tests are yelling at me that some slony libraries are not found in the new 9.4 binaries:<br clear="all"></div><br><div><div><div><div><div>Could not load library "$libdir/slony1_funcs"<br>ERROR: could not access file "$libdir/slony1_funcs": No such file or directory<br><br></div><div>Hopefully it is just and issue of copying the slony binaries from 9.2 to the same libraries in 9.4 on master and slave, or is a re-creation necessary? (We are running slony 2.2.3) <br><br></div><div>I did check on <a href="http://www.slony.info" target="_blank">www.slony.info</a> and didn't find any reference to pg_upgrade.<br><br></div><div>Thanks for your time and insights<br></div><div><br>-- <br><div><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div></div></div></div></div></div>
<br>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div><br></div>