<html><head></head><body><div class="ydp3a294038yahoo-style-wrap" style="font-family:times new roman, new york, times, serif;font-size:16px;"><div><div dir="ltr" data-setdir="false">Hello Sandro, Thanks for your support.<br><br> Please here are the out put to the queries you suggested.<br><br>I have also attached the output in text document in a clearer format.<br><br>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?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br>1.<br><div><div>postgres=# SELECT postgis_full_version();</div><div> postgis_full_version </div><div> </div><div>-----------------------------------------------------------------------------------------------------------------------------------------------------------</div><div>-----------------</div><div> 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</div><div>ON="0.11" RASTER</div><div>(1 row)</div><div><br></div><div>2.</div><div>postgres=# SELECT oid::regprocedure,probin</div><div> FROM pg_catalog.pg_proc</div><div> WHERE proname LIKE 'postgis_%version';</div><div> oid | probin </div><div>------------------------------+-----------------------</div><div> postgis_version() | $libdir/postgis-2.3</div><div> postgis_liblwgeom_version() | $libdir/postgis-2.3</div><div> postgis_proj_version() | $libdir/postgis-2.3</div><div> postgis_lib_version() | $libdir/postgis-2.3</div><div> postgis_geos_version() | $libdir/postgis-2.3</div><div> postgis_svn_version() | $libdir/postgis-2.3</div><div> postgis_libxml_version() | $libdir/postgis-2.3</div><div> postgis_full_version() | </div><div> postgis_libjson_version() | $libdir/postgis-2.3</div><div> postgis_raster_lib_version() | $libdir/rtpostgis-2.3</div><div> postgis_gdal_version() | $libdir/rtpostgis-2.3</div><div>(11 rows)</div><div><br></div><div>postgres=# </div></div><br></div><div><br></div><div class="ydp3a294038signature"><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_3753619601" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, August 23, 2023 at 11:31:11 AM EDT, Sandro Santilli <strk@kbt.io> wrote:
</div>
<div><br></div>
<div><br></div>
<div>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?<div class="yqt4052005438" id="yqtfd92659"><br clear="none"><br clear="none"> SELECT postgis_full_version();</div><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 shape="rect" href="https://strk.kbt.io/services.html" target="_blank">https://strk.kbt.io/services.html</a><div class="yqt4052005438" id="yqtfd72581"><br clear="none"></div></div>
</div>
</div></body></html>