<div dir="ltr">Hi Team,<div><br></div><div>I have followed the steps mentioned by Regina. Just to add a few more details. After database upgrade you may see below message:</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">upgrade_testdb_dev=# SELECT postgis_full_version();</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>postgis_full_version<span class="gmail-Apple-converted-space"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0);min-height:17px"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">---------------</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>POSTGIS="3.1.2 cbe925d" [EXTENSION] PGSQL="110" (procs need upgrade for use with PostgreSQL "130") GEOS="3.9.1-CAPI-1.14.2" PROJ="7.2.1" GDAL="GDAL 3.2.3, released 2021/04/27" LIBXML="2.9.1" LIBJSON="0.11" T</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">OPOLOGY RASTER</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">(1 row)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0);min-height:17px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
</div><div><br></div><div>Run the upgrade command again to resolve this on Pg13</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">upgrade_testdb_dev=# SELECT postgis_extensions_upgrade();</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">NOTICE:<span class="gmail-Apple-converted-space"> </span>Updating extension postgis 3.1.2</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">NOTICE:<span class="gmail-Apple-converted-space"> </span>Extension postgis_sfcgal is not available or not packagable for some reason</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">NOTICE:<span class="gmail-Apple-converted-space"> </span>Extension postgis_tiger_geocoder is not available or not packagable for some reason</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>postgis_extensions_upgrade<span class="gmail-Apple-converted-space"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-------------------------------------------------------------------</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>Upgrade completed, run SELECT postgis_full_version(); for details</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0);min-height:17px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">upgrade_testdb_dev=# SELECT postgis_full_version();</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>postgis_full_version <span class="gmail-Apple-converted-space"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">----------------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>POSTGIS="3.1.2 cbe925d" [EXTENSION] PGSQL="130" GEOS="3.9.1-CAPI-1.14.2" PROJ="7.2.1" GDAL="GDAL 3.2.3, released 2021/04/27" LIBXML="2.9.1" LIBJSON="0.11" TOPOLOGY RASTER</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Monaco;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">(1 row)</span></p>
<br class="gmail-Apple-interchange-newline"></div><div><br></div><div>I have seen one blog which says that a direct upgrade from 2.4.6 to 3.1.2 has many dependencies on raster functions and we should upgrade to 3.1.1 and then to 3.1.2. They have mentioned postgis 2.4.6 but Is it valid in my case also? I am upgrading postgis from 2.5.4 to 3.1.2.</div><div><br></div><div>Blog - <a href="https://www.enterprisedb.com/docs/postgis/3.1.2/03_upgrading_postgis/#example-2">https://www.enterprisedb.com/docs/postgis/3.1.2/03_upgrading_postgis/#example-2</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 27, 2022 at 3:26 PM Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">On Wed, Jan 26, 2022 at 04:04:51PM -0500, Regina Obe wrote:<br>
<br>
> In addition, having the lib not change, means you are not fully upgraded<br>
> until you run the <br>
> <br>
> SELECT postgis_extensions_upgrade() or ALTER EXTENSION ..<br>
<br>
This is STILL the case. You are NOT fully upgraded until you run<br>
<br>
SELECT postgis_extensions_upgrade()<br>
<br>
Let's make it very clear for users that upgrading files on the<br>
operating system level is NOT enough for upgrading postgis databases.<br>
<br>
> Which means for basic use, you can easily test with just the new lib, and<br>
> back out of an upgrade by uninstalling the new version and reinstalling the<br>
> old version.<br>
<br>
You would really only be testing specific kind of changes (not any new<br>
or changed signature, not any script-only speedup or refactoring or bugfix)<br>
and could also incur in crashes due to scripts being incompatible with<br>
underlying library. Let's remember we currently have NO automated test<br>
coverage of these kind of upgrades.<br>
<br>
--strk;<br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>