<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:"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:Monaco;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.gmail-apple-converted-space
{mso-style-name:gmail-apple-converted-space;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Nikhil,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Your install looks fine. The only thing I would recommend is if you don’t need raster support, you can drop it with:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>DROP EXTENSION postgis_raster;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If the above fails with has dependencies, like a table column, then you are using raster.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regarding this:<o:p></o:p></span></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Going from 2.4.6 to 3.1.2 straight – the only reason I can think of is that there were some view issues with changes in PostgreSQL 12 I think, that we had to correct to accommodate upgrading to 12. Those were added after 2.4.6 (so doing a pg_upgrade from saying 2.4.6 to 12 would fail. Using the latest 2.4 should work though. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Now going from 2.5.4 to 3.1.2 – depends on the version. It looks like you upgraded your 11 to 3.1.2 before pg_upgrading? If that is the case, you are fine.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>The only concern I had was how well repacking postgis_raster extension would work in PostgreSQL 13 since they removed the “from unpackaged” feature. If you can<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>DROP EXTENSION postgis_raster;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Then your setup is fine. The only danger is having loose raster functions dangling around.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Sandro,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Can you remind me, I think you figured out a way around the raster unpackaged issue so it works in PG 13 too so it should be possible for someone to go straight from say PG 9.x 2.4 to PG 13 3.x<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></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><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Nikhil Shetty<br><b>Sent:</b> Friday, January 28, 2022 12:12 AM<br><b>To:</b> PostGIS Development Discussion <postgis-devel@lists.osgeo.org><br><b>Subject:</b> Re: [postgis-devel] Upgrade PostGIS from 2.5.4 to 3.1.2<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi Team,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I have followed the steps mentioned by Regina. Just to add a few more details. After database upgrade you may see below message:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>upgrade_testdb_dev=# SELECT postgis_full_version();<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>postgis_full_version<span class=gmail-apple-converted-space> </span><o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:17px'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'><o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>---------------<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>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<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>OPOLOGY RASTER<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>(1 row)<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:17px'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Run the upgrade command again to resolve this on Pg13<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>upgrade_testdb_dev=# SELECT postgis_extensions_upgrade();<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>NOTICE:<span class=gmail-apple-converted-space> </span>Updating extension postgis 3.1.2<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>NOTICE:<span class=gmail-apple-converted-space> </span>Extension postgis_sfcgal is not available or not packagable for some reason<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>NOTICE:<span class=gmail-apple-converted-space> </span>Extension postgis_tiger_geocoder is not available or not packagable for some reason<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>postgis_extensions_upgrade<span class=gmail-apple-converted-space> </span><o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>-------------------------------------------------------------------<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>Upgrade completed, run SELECT postgis_full_version(); for details<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:17px'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>upgrade_testdb_dev=# SELECT postgis_full_version();<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>postgis_full_version <span class=gmail-apple-converted-space> </span><o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>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<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Monaco",serif;color:black'>(1 row)<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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><o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Thu, Jan 27, 2022 at 3:26 PM Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal>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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><o:p></o:p></p></blockquote></div></div></div></body></html>