<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1469398591413_154469">hi Andy / All,</div><div id="yui_3_16_0_ym19_1_1469398591413_154470"><br></div><div id="yui_3_16_0_ym19_1_1469398591413_154471">Thanks for the help I installed postGIS 2.2.0 in the Postgresql 9.3.8 and tried upgrade.</div><div id="yui_3_16_0_ym19_1_1469398591413_154471">It just waits for ages and nothing happens except for the below message.</div><div id="yui_3_16_0_ym19_1_1469398591413_154471"><br></div><div id="yui_3_16_0_ym19_1_1469398591413_154514">alter extension postgis update to '2.2.0';</div><div id="yui_3_16_0_ym19_1_1469398591413_154515">WARNING: 'postgis.backend' is already set and cannot be changed until you reconnect</div><div id="yui_3_16_0_ym19_1_1469398591413_154516">CONTEXT: SQL statement "SELECT postgis_lib_version()"</div><div id="yui_3_16_0_ym19_1_1469398591413_154517">PL/pgSQL function postgis_major_version_check() line 21 at SQL statement</div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518"><br id="yui_3_16_0_ym19_1_1469398591413_154519"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518">is it because of any issues with libraries or a bug?</div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518">Regards,</div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154518">Karthick</div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1469398591413_154460"><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1469398591413_154445" style="display: block;"> <div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1469398591413_154444"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1469398591413_154443"> <div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154522"> <font size="2" face="Arial" id="yui_3_16_0_ym19_1_1469398591413_154521"> <hr size="1" id="yui_3_16_0_ym19_1_1469398591413_154520"> <b><span style="font-weight:bold;">From:</span></b> Pierre Bails <bails@getredbird.com><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, 26 July 2016 6:05 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Help with PostGIS upgrade<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1469398591413_154442"><br><div id="yiv0251986846"><div id="yui_3_16_0_ym19_1_1469398591413_154441"><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154440">Hi,<div><br clear="none"></div><div>This works for us on Debian Jessie. It should also work on Ubuntu.</div><div><br clear="none"></div><div id="yui_3_16_0_ym19_1_1469398591413_154439"><div style="color:rgb(33,33,33);"><font face="monospace, monospace"># install laster version of postgres & postgis</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">$ sudo apt-get install postgresql-9.5 postgresql-9.5-postgis-2.2 postgresql-9.5-postgis-2.2-scripts postgresql-client-9.5 postgresql-contrib-9.5</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"># stop and drop the cluster 9.5 (if exists)</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">$ sudo pg_dropcluster 9.5 main --stop</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"># Upgrade the 9.3 cluster to the latest version. (very long, depending of datasize)</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">$ sudo pg_upgradecluster 9.3 main</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"># check the cluster list</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">$ pg_lsclusters </font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">Ver Cluster Port Status Owner Data directory Log file</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">9.3 main 5433 down postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">9.5 main 5432 online postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div><div style="color:rgb(33,33,33);" id="yui_3_16_0_ym19_1_1469398591413_154438"><font face="monospace, monospace" id="yui_3_16_0_ym19_1_1469398591413_154437"># after works fine, drop the old cluster</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace">$ sudo pg_dropcluster 9.3 main</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div><div style="color:rgb(33,33,33);" id="yui_3_16_0_ym19_1_1469398591413_154456"><font face="monospace, monospace"># then, remove old packages</font></div><div style="color:rgb(33,33,33);"><font face="monospace, monospace"><br clear="none"></font></div>Good luke !</div><div><br clear="none"></div><div>Pierre</div><div class="yiv0251986846yqt9715483279" id="yiv0251986846yqt67421"><div id="yui_3_16_0_ym19_1_1469398591413_154450"><div class="yiv0251986846gmail_quote" id="yui_3_16_0_ym19_1_1469398591413_154449"><div class="yiv0251986846GmSign" id="yui_3_16_0_ym19_1_1469398591413_154454"><br clear="none"><div dir="ltr"><div><div><div dir="ltr"><div dir="ltr"><div dir="ltr" style="font-size:12.8px;"></div></div></div></div></div></div><br clear="none"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1469398591413_154452">Le lun. 25 juil. 2016 à 23:37, Andy Colson <<a rel="nofollow" shape="rect" ymailto="mailto:andy@squeakycode.net" target="_blank" href="mailto:andy@squeakycode.net" id="yui_3_16_0_ym19_1_1469398591413_154453">andy@squeakycode.net</a>> a écrit :<br clear="none"></div><blockquote class="yiv0251986846gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;" id="yui_3_16_0_ym19_1_1469398591413_154448">On 7/25/2016 3:49 PM, Karthick Thanigaimani wrote:<br clear="none">
> Hi,<br clear="none">
><br clear="none">
><br clear="none">
><br clear="none">
> We have a database that is of ~1 TB and the schemas are big as well. We<br clear="none">
> would like to upgrade the database version from PostgreSQL 9.3.x to<br clear="none">
> 9.5.x and the DB has PostGIS 2.1.2 which also need to be updated to<br clear="none">
> 2.2.2 as per version 9.5.x.<br clear="none">
> I installed the postGIS 2.2.2 libraries and tried updating the version<br clear="none">
> 2.2.2 but it says there is no upgrade path.<br clear="none">
> and when we run the pg_upgrade compatibility check it says postGIS has<br clear="none">
> to be upgraded.<br clear="none">
><br clear="none">
><br clear="none">
> Is there anyway to achieve the upgrade without doing pg_dump of the<br clear="none">
> schemas.?<br clear="none">
><br clear="none">
> Please can anyone help.<br clear="none">
><br clear="none">
> thank you.<br clear="none">
><br clear="none">
> Regards,<br clear="none">
> Karthick<br clear="none">
<br clear="none">
I just did this actually. I first upgraded my PG9.3 to Postgis 2.2.2,<br clear="none">
then I used pg_upgrade to go from 9.3 to 9.5, which worked fine.<br clear="none">
<br clear="none">
Sounds like you had problems in PG9.3 upgrading Postgis. That should<br clear="none">
work ok.<br clear="none">
<br clear="none">
Really, though, if should not matter which you upgrade first. Can you<br clear="none">
install PostGIS 2.1.2 into PG 9.5? If so, do that and upgrade PG first.<br clear="none">
It should work ok.<br clear="none">
<br clear="none">
-Andy<br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
postgis-users mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" target="_blank" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div></div></div></div></div><br><div class="yqt9715483279" id="yqt75424">_______________________________________________<br clear="none">postgis-users mailing list<br clear="none"><a shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none"><a shape="rect" href="http://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></div><br><br></div> </div> </div> </div></div></body></html>