<html><head></head><body><div class="ydp25210c52yahoo-style-wrap" style="font-family:times new roman, new york, times, serif;font-size:16px;"><div><div dir="ltr" data-setdir="false">Thank you Regina,<br>As mentioned earlier I tried the soft upgrade and it failed. Also the hard upgrade is not an option for me since it involves taking a dump of the DB and restoring(because of several environmental variables :huge database sizes, limited downtime window, etc).</div><div><br></div><div class="ydp25210c52signature"><div style="font-family:new times, serif;font-size:16px;"><font face="lucida console, sans-serif"><font style="font-size:16px;">--------------------------------------------<font color="#ffffff">- </font></font></font><div dir="ltr">Marcelius Atanga</div><div dir="ltr">Tel: +13025384841</div><span style="font-family:serif;font-size:16px;background-color:rgb(255, 255, 255);"><font color="#5b8828" style="background-color: inherit;"><br><span style="font-family:serif;font-weight:bold;font-size:small;"> </span></font><span style="font-family:serif;font-size:small;color:rgb(112, 172, 237);"> <br></span></span><div style="display:none;" id="ydp4fbbcc0skype_c2c_menu_container" class="ydp4fbbcc0skype_c2c_menu_container ydp4fbbcc0notranslate"><div class="ydp4fbbcc0skype_c2c_menu_click2call"><a id="ydp4fbbcc0skype_c2c_menu_click2call_action" class="ydp4fbbcc0skype_c2c_menu_click2call_action">Call</a></div><div class="ydp4fbbcc0skype_c2c_menu_click2sms"><a id="ydp4fbbcc0skype_c2c_menu_click2sms_action" class="ydp4fbbcc0skype_c2c_menu_click2sms_action">Send SMS</a></div><div class="ydp4fbbcc0skype_c2c_menu_push_to_mobile"><a id="ydp4fbbcc0skype_c2c_menu_push_to_mobile_action" class="ydp4fbbcc0skype_c2c_menu_push_to_mobile_action">Call from mobile</a></div><div class="ydp4fbbcc0skype_c2c_menu_add2skype"><a id="ydp4fbbcc0skype_c2c_menu_add2skype_text" class="ydp4fbbcc0skype_c2c_menu_add2skype_text">Add to Skype</a></div><div class="ydp4fbbcc0skype_c2c_menu_toll_info"><span class="ydp4fbbcc0skype_c2c_menu_toll_callcredit">You'll need Skype Credit</span><span class="ydp4fbbcc0skype_c2c_menu_toll_free">Free via Skype</span></div></div></div></div></div>
<div><br></div><div><br></div>
</div><div id="yahoo_quoted_4050169561" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, August 30, 2023 at 09:36:33 AM EDT, Regina Obe <lr@pcorp.us> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv6746310694"><style><!--
#yiv6746310694 filtered {}
#yiv6746310694 filtered {}
#yiv6746310694 filtered {}
#yiv6746310694 filtered {}
#yiv6746310694 p.yiv6746310694MsoNormal, #yiv6746310694 li.yiv6746310694MsoNormal, #yiv6746310694 div.yiv6746310694MsoNormal
{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}
#yiv6746310694 a:link, #yiv6746310694 span.yiv6746310694MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv6746310694 p.yiv6746310694MsoPlainText, #yiv6746310694 li.yiv6746310694MsoPlainText, #yiv6746310694 div.yiv6746310694MsoPlainText
{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}
#yiv6746310694 span.yiv6746310694ydp4fbbcc0skypec2cmenutollcallcredit
{}
#yiv6746310694 span.yiv6746310694ydp4fbbcc0skypec2cmenutollfree
{}
#yiv6746310694 span.yiv6746310694EmailStyle21
{font-family:"Calibri", sans-serif;color:windowtext;}
#yiv6746310694 span.yiv6746310694PlainTextChar
{font-family:"Calibri", sans-serif;}
#yiv6746310694 .yiv6746310694MsoChpDefault
{font-size:10.0pt;}
#yiv6746310694 filtered {}
#yiv6746310694 div.yiv6746310694WordSection1
{}
--></style><div><div class="yiv6746310694WordSection1"><p class="yiv6746310694MsoPlainText">Marcelius,</p><p class="yiv6746310694MsoPlainText"> </p><p class="yiv6746310694MsoPlainText">So you installed PostGIS from scripts right? </p><p class="yiv6746310694MsoPlainText">I think your best bet is to upgrade your PostgreSQL 9.6 using scripts</p><p class="yiv6746310694MsoPlainText"> </p><p class="yiv6746310694MsoPlainText">1) Get a PostGIS 3.0 or higher for PostgreSQL 9.6 (it can be from a yum repo or compiled yourself). Preferable a PostGIS 3.1 (I think 3.1 is the last version supported for PostgreSQL 9.6) if you can get it.</p><p class="yiv6746310694MsoPlainText">2) Run the postgis_upgrade.sql script, which should be in the contrib/postgis-<version> folder of your install </p><p class="yiv6746310694MsoPlainText">As detailed here: <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script">https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script</a></p><p class="yiv6746310694MsoPlainText"> </p><p class="yiv6746310694MsoPlainText">You can call pg_config --sharedir</p><p class="yiv6746310694MsoNormal">To figure out the path of the shared folder if you don’t know it.</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">You may need to run the raster and other upgrade scripts too. To confirm do something like</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">SELECT * FROM raster_columns;</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">If that doesn’t error out, you have raster support in there too that needs to be upgraded</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">3) Once you’ve upgraded your PostgreSQL 9.6 using the scripts, run</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">SELECT postgis_extensions_upgrade();</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">That should if you are running PostGIS 3+ or higher to an extension based install.</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">Sandro, remember which version of this we started flipping everyone to extension based install? I think 3.1 was after that time</p><p class="yiv6746310694MsoNormal"> </p><p class="yiv6746310694MsoNormal">Hope that helps,</p><p class="yiv6746310694MsoNormal">Regina</p><p class="yiv6746310694MsoNormal"> </p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;"><div id="yiv6746310694yqt05664" class="yiv6746310694yqt9584388645"><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in;"><p class="yiv6746310694MsoNormal"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> <b>On Behalf Of </b>atanga MARCELIUS via postgis-users<br clear="none"><b>Sent:</b> Wednesday, August 30, 2023 5:51 AM<br clear="none"><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org>; Sandro Santilli <strk@kbt.io><br clear="none"><b>Cc:</b> atanga MARCELIUS <marx407@yahoo.ca><br clear="none"><b>Subject:</b> Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3</p></div></div><p class="yiv6746310694MsoNormal"> </p><div><div><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Hello Sandro, Thanks for your support.<br clear="none"><br clear="none"> Please here are the out put to the queries you suggested.<br clear="none"><br clear="none">I have also attached the output in text document in a clearer format.<br clear="none"><br clear="none">My main concern here is how to manage the upgrade path from postgis 2.3 in postgresql 9.6 to a compactible version of postgis in postgresql14 given that postgis 2.3 was hard install(using source code) and given my environmental challenges I do not want to do a dump and restore?</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"><br clear="none">1.</span></p><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">postgres=# SELECT postgis_full_version();</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_full_version </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">-----------------------------------------------------------------------------------------------------------------------------------------------------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">-----------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> POSTGIS="2.3.7 r16523" PGSQL="100" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJS</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">ON="0.11" RASTER</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">(1 row)</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">2.</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">postgres=# SELECT oid::regprocedure,probin</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> FROM pg_catalog.pg_proc</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> WHERE proname LIKE 'postgis_%version';</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> oid | probin </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">------------------------------+-----------------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_liblwgeom_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_proj_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_lib_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_geos_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_svn_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_libxml_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_full_version() | </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_libjson_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_raster_lib_version() | $libdir/rtpostgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> postgis_gdal_version() | $libdir/rtpostgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">(11 rows)</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">postgres=# </span></p></div></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;"> </span></p></div></div></div><p class="yiv6746310694MsoNormal"> </p></div><div><p class="yiv6746310694MsoNormal"> </p></div><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;">--------------------------------------------<span style="color:white;">- </span></span><span style="font-size:12.0pt;font-family:New serif;"></span></p><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Marcelius Atanga</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Tel: +13025384841</span></p></div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#5B8828;background:white;"><br clear="none"><b> </b></span><span style="font-size:12.0pt;font-family:New serif;color:#70ACED;background:white;"> </span><span style="font-size:12.0pt;font-family:New serif;"></span></p><div id="yiv6746310694ydp4fbbcc0skype_c2c_menu_container"><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Call</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Send SMS</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Call from mobile</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;">Add to Skype</span></p></div><div><p class="yiv6746310694MsoNormal"><span class="yiv6746310694ydp4fbbcc0skypec2cmenutollcallcredit"><span style="font-size:12.0pt;font-family:New serif;">You'll need Skype Credit</span></span><span class="yiv6746310694ydp4fbbcc0skypec2cmenutollfree"><span style="font-size:12.0pt;font-family:New serif;">Free via Skype</span></span><span style="font-size:12.0pt;font-family:New serif;"></span></p></div></div></div></div></div><div><p class="yiv6746310694MsoNormal"> </p></div><div><p class="yiv6746310694MsoNormal"> </p></div></div><div id="yiv6746310694yahoo_quoted_3944523870"><div><div id="yiv6746310694yqt64916" class="yiv6746310694yqt9584388645"><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On Tuesday, August 29, 2023 at 02:55:37 AM EDT, atanga MARCELIUS <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:marx407@yahoo.ca" target="_blank" href="mailto:marx407@yahoo.ca">marx407@yahoo.ca</a>> wrote: </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p></div></div><div><div id="yiv6746310694yqt79129" class="yiv6746310694yqt9584388645"><div><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Hello Sandro, Thanks for your support.<br clear="none"><br clear="none"> Please here are the out put to the queries you suggested.<br clear="none"><br clear="none">I have also attached the output in text document in a clearer format.<br clear="none"><br clear="none">My main concern here is how to manage the upgrade path from postgis 2.3 in postgresql 9.6 to a compactible version of postgis in postgresql14 given that postgis 2.3 was hard install(using source code) and given my environmental challenges I do not want to do a dump and restore?</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"><br clear="none">1.</span></p><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">postgres=# SELECT postgis_full_version();</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_full_version </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">-----------------------------------------------------------------------------------------------------------------------------------------------------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">-----------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> POSTGIS="2.3.7 r16523" PGSQL="100" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJS</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">ON="0.11" RASTER</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">(1 row)</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">2.</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">postgres=# SELECT oid::regprocedure,probin</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> FROM pg_catalog.pg_proc</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> WHERE proname LIKE 'postgis_%version';</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> oid | probin </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">------------------------------+-----------------------</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_liblwgeom_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_proj_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_lib_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_geos_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_svn_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_libxml_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_full_version() | </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_libjson_version() | $libdir/postgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_raster_lib_version() | $libdir/rtpostgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> postgis_gdal_version() | $libdir/rtpostgis-2.3</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">(11 rows)</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">postgres=# </span></p></div></div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;color:#26282A;">--------------------------------------------</span><span style="font-size:12.0pt;color:white;">- </span><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"></span></p><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Marcelius Atanga</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Tel: +13025384841</span></p></div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#5B8828;background:white;"><br clear="none"><b> </b></span><span style="font-size:12.0pt;font-family:New serif;color:#70ACED;background:white;"> </span><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"></span></p><div id="yiv6746310694ydp4fbbcc0skype_c2c_menu_container"><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Call</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Send SMS</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Call from mobile</span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Add to Skype</span></p></div><div><p class="yiv6746310694MsoNormal"><span class="yiv6746310694ydp4fbbcc0skypec2cmenutollcallcredit"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">You'll need Skype Credit</span></span><span class="yiv6746310694ydp4fbbcc0skypec2cmenutollfree"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;">Free via Skype</span></span><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"></span></p></div></div></div></div></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:12.0pt;font-family:New serif;color:#26282A;"> </span></p></div></div></div><div id="yiv6746310694yahoo_quoted_3753619601"><div><div id="yiv6746310694yqt70795" class="yiv6746310694yqt9584388645"><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On Wednesday, August 23, 2023 at 11:31:11 AM EDT, Sandro Santilli <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:strk@kbt.io" target="_blank" href="mailto:strk@kbt.io">strk@kbt.io</a>> wrote: </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p></div><div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p></div></div><div><div id="yiv6746310694yqt16686" class="yiv6746310694yqt9584388645"><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On Wed, Aug 23, 2023 at 10:08:23AM +0000, atanga MARCELIUS wrote:<br clear="none"><br clear="none">> xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';<br clear="none">> ERROR: extension "postgis" does not exist<br clear="none"><br clear="none">The above message means that database "xxxxx" does not contain<br clear="none">the "postgis extension". This does not necessarely mean it doesn't<br clear="none">contain postgis objects, if you're coming from a very old install<br clear="none">as you seem to be coming from.<br clear="none"><br clear="none">What does this query return?</span></p><div id="yiv6746310694yqtfd92659"><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"><br clear="none"><br clear="none"> SELECT postgis_full_version();</span></p></div><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"><br clear="none"><br clear="none">And this one ?<br clear="none"><br clear="none"> SELECT oid::regprocedure,probin<br clear="none"> FROM pg_catalog.pg_proc<br clear="none"> WHERE proname LIKE 'postgis_%version';<br clear="none"><br clear="none">--strk;<br clear="none"><br clear="none"> Libre GIS consultant/developer<br clear="none"> <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://strk.kbt.io/services.html">https://strk.kbt.io/services.html</a></span></p></div><div id="yiv6746310694yqtfd72581"><p class="yiv6746310694MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
</div></body></html>