<div dir="ltr">Good afternoon,<div><br></div><div>I am attempting to run pg_upgrade with the link option to upgrade from postgres 9.2.12 to 9.4.8. Within the current 9.2.12 setup I have slony1-2.2.3 running.</div><div><br></div><div>This is what I have attempted so far:</div><div> 1. installed postgres 9.4.8 on the same file system as 9.2 from tarball source</div><div> 1. killed slony (on 9.2)</div><div> 2. stopped postgres</div><div> 3. ran 9.4.8 initdb </div><div> 4. installed slony1-2.2.3 on the new 9.4.8 setup from tarball source (here is the command)</div><div> <font color="#0000ff"> ./configure --prefix=/usr/local/postgresql-9.4.8/bin --with-pgconfigdir=/usr/local/postgresql-9.4.8/bin --with-perltools=/usr/local/postgresql-9.4.8/bin --with-pglibdir=/usr/local/postgresql-9.4.8/lib --with-pgpkglibdir=/usr/local/postgresql-9.4.8/lib </font></div><div><font color="#0000ff"> make</font></div><div><font color="#0000ff"> make install</font></div><div><br></div><div> 5. attempted pg_upgrade (here is the command)<br clear="all"><div> <font color="#0000ff"> /usr/local/postgresql-9.4.8/bin/pg_upgrade -b /usr/local/postgresql-9.2.11/bin -B /usr/local/postgresql-9.4.8/bin -d /data/PSQL_9.2 -D /data/PSQL_9.4 -k -v & </font></div><div><font color="#0000ff"><br></font></div><div><font color="#000000">I am now getting an error from this indicating a version mismatch:</font></div><div><font color="#000000"> </font><font color="#0000ff"> Could not load library "$libdir/slony1_funcs.2.2.3"</font></div><div><font color="#0000ff">ERROR: incompatible library "/usr/local/postgresql-9.4.8/lib/<a href="http://slony1_funcs.2.2.3.so">slony1_funcs.2.2.3.so</a>": version mismatch</font></div><div><font color="#0000ff">DETAIL: Server is version 9.4, library is version 9.2.</font></div><div><font color="#0000ff"><br></font></div><div><font color="#000000">I then installed slony1-2.2.5 with the above command, ran the same pg_upgrade command and got the exact same error. Then I deleted the <a href="http://slony1_funcs.2.2.3.so">slony1_funcs.2.2.3.so</a> file from my library directory leaving the <a href="http://slony1_funcs.2.2.5.so">slony1_funcs.2.2.5.so</a> and attempted the upgrade. This time it errored out with a NOT FOUND condition on the <a href="http://slony1_funcs.2.2.3.so">slony1_funcs.2.2.3.so</a>. So I'm not sure what to do next. I looked at <a href="http://slony.info">slony.info</a> to see if it shed any light on compatibilities between slony versions and postgres versions and didn't find anything.</font></div><div><font color="#000000"><br></font></div><div><font color="#000000">A note: without slony installed in either instance the upgrade is successful.</font></div><div><font color="#000000"><br></font></div><div><font color="#000000">Any help / insight appreciated. Thank you</font></div><div><br></div><div><font color="#000000"> </font></div><div><br></div>-- <br><div class="gmail_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-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>