<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
span.ydp4fbbcc0skypec2cmenutollcallcredit
{mso-style-name:ydp4fbbcc0skype_c2c_menu_toll_callcredit;}
span.ydp4fbbcc0skypec2cmenutollfree
{mso-style-name:ydp4fbbcc0skype_c2c_menu_toll_free;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoPlainText>Marcelius,<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>So you installed PostGIS from scripts right? <o:p></o:p></p><p class=MsoPlainText>I think your best bet is to upgrade your PostgreSQL 9.6 using scripts<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>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.<o:p></o:p></p><p class=MsoPlainText>2) Run the postgis_upgrade.sql script, which should be in the contrib/postgis-<version> folder of your install <o:p></o:p></p><p class=MsoPlainText>As detailed here: <a href="https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script">https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script</a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>You can call pg_config --sharedir<o:p></o:p></p><p class=MsoNormal>To figure out the path of the shared folder if you don’t know it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>You may need to run the raster and other upgrade scripts too. To confirm do something like<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>SELECT * FROM raster_columns;<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If that doesn’t error out, you have raster support in there too that needs to be upgraded<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>3) Once you’ve upgraded your PostgreSQL 9.6 using the scripts, run<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>SELECT postgis_extensions_upgrade();<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>That should if you are running PostGIS 3+ or higher to an extension based install.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sandro, remember which version of this we started flipping everyone to extension based install? I think 3.1 was after that time<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hope that helps,<o:p></o:p></p><p class=MsoNormal>Regina<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> <b>On Behalf Of </b>atanga MARCELIUS via postgis-users<br><b>Sent:</b> Wednesday, August 30, 2023 5:51 AM<br><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org>; Sandro Santilli <strk@kbt.io><br><b>Cc:</b> atanga MARCELIUS <marx407@yahoo.ca><br><b>Subject:</b> Re: [postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>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?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><br>1.<o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>postgres=# SELECT postgis_full_version();<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_full_version <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>-----------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>-----------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",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<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>ON="0.11" RASTER<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>(1 row)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>2.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>postgres=# SELECT oid::regprocedure,probin<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> FROM pg_catalog.pg_proc<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> WHERE proname LIKE 'postgis_%version';<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> oid | probin <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>------------------------------+-----------------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_liblwgeom_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_proj_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_lib_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_geos_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_svn_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_libxml_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_full_version() | <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_libjson_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_raster_lib_version() | $libdir/rtpostgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'> postgis_gdal_version() | $libdir/rtpostgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>(11 rows)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>postgres=# <o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p> </o:p></span></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Lucida Console"'>--------------------------------------------<span style='color:white'>- </span></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Marcelius Atanga<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Tel: +13025384841<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#5B8828;background:white'><br><b> </b></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#70ACED;background:white'> </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p></o:p></span></p><div id="ydp4fbbcc0skype_c2c_menu_container"><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Call<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Send SMS<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Call from mobile<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Add to Skype<o:p></o:p></span></p></div><div><p class=MsoNormal><span class=ydp4fbbcc0skypec2cmenutollcallcredit><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>You'll need Skype Credit</span></span><span class=ydp4fbbcc0skypec2cmenutollfree><span style='font-size:12.0pt;font-family:"Times New Roman",serif'>Free via Skype</span></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif'><o:p></o:p></span></p></div></div></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div id="yahoo_quoted_3944523870"><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Tuesday, August 29, 2023 at 02:55:37 AM EDT, atanga MARCELIUS <<a href="mailto:marx407@yahoo.ca">marx407@yahoo.ca</a>> wrote: <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>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?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><br>1.<o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>postgres=# SELECT postgis_full_version();<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_full_version <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>-----------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>-----------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",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<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>ON="0.11" RASTER<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>(1 row)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>2.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>postgres=# SELECT oid::regprocedure,probin<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> FROM pg_catalog.pg_proc<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> WHERE proname LIKE 'postgis_%version';<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> oid | probin <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>------------------------------+-----------------------<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_liblwgeom_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_proj_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_lib_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_geos_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_svn_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_libxml_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_full_version() | <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_libjson_version() | $libdir/postgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_raster_lib_version() | $libdir/rtpostgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'> postgis_gdal_version() | $libdir/rtpostgis-2.3<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>(11 rows)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>postgres=# <o:p></o:p></span></p></div></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Lucida Console";color:#26282A'>--------------------------------------------</span><span style='font-size:12.0pt;font-family:"Lucida Console";color:white'>- </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Marcelius Atanga<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Tel: +13025384841<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#5B8828;background:white'><br><b> </b></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#70ACED;background:white'> </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p></o:p></span></p><div id="ydp4fbbcc0skype_c2c_menu_container"><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Call<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Send SMS<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Call from mobile<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Add to Skype<o:p></o:p></span></p></div><div><p class=MsoNormal><span class=ydp4fbbcc0skypec2cmenutollcallcredit><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>You'll need Skype Credit</span></span><span class=ydp4fbbcc0skypec2cmenutollfree><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'>Free via Skype</span></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p></o:p></span></p></div></div></div></div></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#26282A'><o:p> </o:p></span></p></div></div><div id="yahoo_quoted_3753619601"><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wednesday, August 23, 2023 at 11:31:11 AM EDT, Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>> wrote: <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wed, Aug 23, 2023 at 10:08:23AM +0000, atanga MARCELIUS wrote:<br><br>> xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';<br>> ERROR: extension "postgis" does not exist<br><br>The above message means that database "xxxxx" does not contain<br>the "postgis extension". This does not necessarely mean it doesn't<br>contain postgis objects, if you're coming from a very old install<br>as you seem to be coming from.<br><br>What does this query return?<o:p></o:p></span></p><div id=yqtfd92659><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><br><br> SELECT postgis_full_version();<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><br><br>And this one ?<br><br> SELECT oid::regprocedure,probin<br> FROM pg_catalog.pg_proc<br> WHERE proname LIKE 'postgis_%version';<br><br>--strk;<br><br> Libre GIS consultant/developer<br> <a href="https://strk.kbt.io/services.html" target="_blank">https://strk.kbt.io/services.html</a><o:p></o:p></span></p><div id=yqtfd72581><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p></div></div></div></div></div></div></div></div></div></body></html>