<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1443568798682_4429"><span>Mark,</span></div><div id="yui_3_16_0_1_1443568798682_4429"><span><br></span></div><div id="yui_3_16_0_1_1443568798682_4429" dir="ltr"><span id="yui_3_16_0_1_1443568798682_4506">Extensions are compiled forspecific PostgreSQL versions, so the slony libraries that were compiled for 9.2 will not run in 9.4. You have to install the slony package or rpm that was compiled for 9.4, or recompile slony yourself. Either option is fairly easy. A short RTFM will yield the answer that works for you.</span></div><div id="yui_3_16_0_1_1443568798682_4429" dir="ltr"><span><br></span></div><div id="yui_3_16_0_1_1443568798682_4429" dir="ltr"><span>Regards,</span></div><div id="yui_3_16_0_1_1443568798682_4429" dir="ltr"><span><br></span></div><div id="yui_3_16_0_1_1443568798682_4429" dir="ltr"><span>Bob Lunney</span></div><br> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1443568798682_4382"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1443568798682_4381"> <div dir="ltr" id="yui_3_16_0_1_1443568798682_4380"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Mark Steben <mark.steben@drivedominion.com><br> <b><span style="font-weight: bold;">To:</span></b> slony <slony1-general@lists.slony.info> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, September 29, 2015 5:23 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Slony1-general] upgrade slony master / slave using pg_upgrade<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1443568798682_4596"><br><div id="yiv0538741049"><div dir="ltr" id="yui_3_16_0_1_1443568798682_4601"><div id="yui_3_16_0_1_1443568798682_4600"><div id="yui_3_16_0_1_1443568798682_4599"><div id="yui_3_16_0_1_1443568798682_4598"><div id="yui_3_16_0_1_1443568798682_4597">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 id="yui_3_16_0_1_1443568798682_4606"><div id="yui_3_16_0_1_1443568798682_4605"><div id="yui_3_16_0_1_1443568798682_4604"><div id="yui_3_16_0_1_1443568798682_4603"><div id="yui_3_16_0_1_1443568798682_4602">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 id="yui_3_16_0_1_1443568798682_4607">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 rel="nofollow" target="_blank" href="http://www.slony.info/">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 id="yui_3_16_0_1_1443568798682_4608"><br>-- <br><div class="yiv0538741049gmail_signature"><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-size:8pt;"><span style="color:rgb(51,51,51);"></span><br><a rel="nofollow" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" target="_blank" href="http://www.autorevenue.com/">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt;">|</span> <a rel="nofollow" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" target="_blank" href="http://www.autobase.net/">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 rel="nofollow" href="">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt;">f: <a rel="nofollow" href="">413.383-9567</a></span> </span></font></span></div><div><span><font color="#888888"><span style="font-size:8pt;"><a rel="nofollow" target="_blank" href="http://www.fb.com/DominionDealerSolutions">www.fb.com/DominionDealerSolutions</a><br><a rel="nofollow" target="_blank" href="http://www.twitter.com/DominionDealer">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt;"> <a rel="nofollow" target="_blank" href="http://www.autorevenue.com/">www.drivedominion.com</a><br><br><a rel="nofollow" target="_blank" href="http://autobasedigital.net/marketing/DD12_sig.jpg"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-size:8pt;"><span style="color:gray;font-size:8pt;"><br></span></span></font></span></div><font color="#888888"></font></div>
</div></div></div></div></div></div></div><br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br><br><br></div> </div> </div> </div></body></html>