<div dir="ltr">Hi,<div><br></div><div>We didn't get any error when we ran the commands</div><div><br></div><div><div style="color:rgb(0,0,0);font-size:12px;line-height:18px;white-space:pre"><div style="font-family:Menlo,Monaco,"Courier New",monospace"><span style="color:rgb(0,0,255)">pg13upgrade_dev</span>=<span style="color:rgb(0,128,0)"># ALTER EXTENSION postgis UPDATE;</span></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">WARNING:  unpackaging raster</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">WARNING:  PostGIS Raster functionality has been unpackaged</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">HINT:  type `SELECT postgis_extensions_upgrade()<span style="color:rgb(0,128,0)">;` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;</span></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">ALTER EXTENSION</div><div style="font-family:Menlo,Monaco,"Courier New",monospace"><span style="color:rgb(0,0,255)">pg13upgrade_dev</span>=<span style="color:rgb(0,128,0)"># SELECT postgis_extensions_upgrade();</span></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">NOTICE:  Extension postgis_sfcgal is not available or not packagable for some reason</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">NOTICE:  Packaging extension postgis_raster</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">NOTICE:  Extension postgis_topology is not available or not packagable for some reason</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">NOTICE:  Extension postgis_tiger_geocoder is not available or not packagable for some reason</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">                    postgis_extensions_upgrade                     </div><div style="font-family:Menlo,Monaco,"Courier New",monospace">-------------------------------------------------------------------</div><div style="font-family:Menlo,Monaco,"Courier New",monospace"> Upgrade completed, run SELECT postgis_full_version()<span style="color:rgb(0,128,0)">; for details</span></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">(1 row)</div><font face="Menlo, Monaco, Courier New, monospace"><br></font><div style="font-family:Menlo,Monaco,"Courier New",monospace"><span style="color:rgb(0,0,255)">pg13upgrade_dev</span>=<span style="color:rgb(0,128,0)"># SELECT postgis_full_version();</span></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">                                                                       postgis_full_version                                                                        </div><div style="font-family:Menlo,Monaco,"Courier New",monospace">-------------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div style="font-family:Menlo,Monaco,"Courier New",monospace"> <span style="color:rgb(0,0,255)">POSTGIS</span>=<span style="color:rgb(163,21,21)">"3.1.2 cbe925d"</span> [EXTENSION] <span style="color:rgb(0,0,255)">PGSQL</span>=<span style="color:rgb(163,21,21)">"130"</span> <span style="color:rgb(0,0,255)">GEOS</span>=<span style="color:rgb(163,21,21)">"3.9.1-CAPI-1.14.2"</span> <span style="color:rgb(0,0,255)">PROJ</span>=<span style="color:rgb(163,21,21)">"7.2.1"</span> <span style="color:rgb(0,0,255)">GDAL</span>=<span style="color:rgb(163,21,21)">"GDAL 3.2.3, released 2021/04/27"</span> <span style="color:rgb(0,0,255)">LIBXML</span>=<span style="color:rgb(163,21,21)">"2.9.1"</span> <span style="color:rgb(0,0,255)">LIBJSON</span>=<span style="color:rgb(163,21,21)">"0.11"</span> RASTER</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">(1 row)</div><div style="font-family:Menlo,Monaco,"Courier New",monospace"><br></div><div style="font-family:Menlo,Monaco,"Courier New",monospace"><br></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">After above step, we removed the symlink as shown below, so now we have Pg13 and Postgis on 3.1.2. </div><div style="font-family:Menlo,Monaco,"Courier New",monospace"><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><font face="arial, sans-serif"><span style="font-variant-ligatures:no-common-ligatures">lrwxrwxrwx.<span class="gmail-Apple-converted-space">  </span>1 root root<span class="gmail-Apple-converted-space">      </span>12 Feb<span class="gmail-Apple-converted-space">  </span>2 09:36 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(41,255,255)"><a href="http://postgis-2.5.so">postgis-2.5.so</a></span><span style="font-variant-ligatures:no-common-ligatures"> -> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(47,189,29)">postgis-3.so</span></font></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><font face="arial, sans-serif"><span style="font-variant-ligatures:no-common-ligatures">lrwxrwxrwx.<span class="gmail-Apple-converted-space">  </span>1 root root<span class="gmail-Apple-converted-space">      </span>19 Feb<span class="gmail-Apple-converted-space">  </span>2 09:37 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(41,255,255)"><a href="http://rtpostgis-2.5.so">rtpostgis-2.5.so</a></span><span style="font-variant-ligatures:no-common-ligatures"> -> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(47,189,29)">postgis_raster-3.so</span></font></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><font face="arial, sans-serif"><br></font></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><span style="font-variant-ligatures:no-common-ligatures"><font face="arial, sans-serif">/usr/pgsql-13/lib # unlink <a href="http://postgis-2.5.so">postgis-2.5.so</a><span class="gmail-Apple-converted-space"> </span></font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><span style="font-variant-ligatures:no-common-ligatures"><font face="arial, sans-serif">/usr/pgsql-13/lib # unlink <a href="http://rtpostgis-2.5.so">rtpostgis-2.5.so</a><span class="gmail-Apple-converted-space"> </span></font></span></p><p style="font-family:Monaco;margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><br></p><p style="font-family:Monaco;margin:0px;font-stretch:normal;font-size:13px;line-height:normal">For now, we are dropping the raster extension since this is test upgrade.</p><p style="font-family:Monaco;margin:0px;font-stretch:normal;font-size:13px;line-height:normal"><br></p></div><div style="font-family:Menlo,Monaco,"Courier New",monospace">Thanks,</div><div style="font-family:Menlo,Monaco,"Courier New",monospace">Nikhil</div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 2, 2022 at 2:44 AM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</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"><div lang="EN-US"><div class="gmail-m_8977348913006607190WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Do you get error after if you do:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">ALTER EXTENSION postgis UPDATE;<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">SELECT postgis_extensions_upgrade();<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Or<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">SELECT postgis_extensions_upgrade();<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">SELECT postgis_extensions_upgrade();<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2.5 on PostgreSQL 13 is not a place you want to stay even if you are running with 3.0 libraries.  <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">You really want to be on PostGIS 3.0 or higher with both the libs and the database updated.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">The reason being that 2.5 has postgis/raster in one extension and upgrading after will become very difficult.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><div style="border-style:none none none solid;border-left-width:1.5pt;border-left-color:blue;padding:0in 0in 0in 4pt"><div><div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-devel [mailto:<a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Nikhil Shetty<br><b>Sent:</b> Saturday, January 29, 2022 12:50 AM<br><b>To:</b> PostGIS Development Discussion <<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-devel] Upgrade PostGIS from 2.5.4 to 3.1.2<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi Team,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">We have found another method that will help to upgrade both postgresql from 11 to 13 and postgis from 2.5.4 to 3.1.2.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Error:<u></u><u></u></p></div><div><p style="margin-right:0in;margin-bottom:12pt;margin-left:0in"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:red">could not load library "$libdir/postgis-2.5": ERROR:  could not access file "$libdir/postgis-2.5": No such file or directory</span><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)"><u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">Resolution: Create a symlink<u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">cd /usr/pgsql-13/lib<br>1) ln -s<span class="gmail-m_8977348913006607190gmail-apple-converted-space"> </span><a href="http://rtpostgis-2.4.so/" target="_blank"><span style="color:rgb(0,112,201);text-decoration:none">postgis-3.so</span></a><span class="gmail-m_8977348913006607190gmail-apple-converted-space"> </span><a href="http://rtpostgis-2.3.so/" target="_blank"><span style="color:rgb(0,112,201);text-decoration:none">postgis-2.5.so</span></a><u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">Once symlink is created proceed with pg_upgrade and it is successful. I wanted to confirm whether this is the right way to go? <u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">Note: We are not changing the symlink after pg_upgrade.<u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)"><u></u> <u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">Thanks,<u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)">Nikhil<u></u><u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)"><u></u> <u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)"><u></u> <u></u></span></p><p style="margin-right:0in;margin-left:0in;margin-bottom:0.0001pt"><span style="font-size:10.5pt;font-family:Helvetica,sans-serif;color:rgb(23,43,77)"><u></u> <u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Fri, Jan 28, 2022 at 5:44 PM Sandro Santilli <<a href="mailto:strk@kbt.io" target="_blank">strk@kbt.io</a>> wrote:<u></u><u></u></p></div><blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><p class="MsoNormal">On Fri, Jan 28, 2022 at 12:40:31AM -0500, Regina Obe wrote:<br><br>> Sandro,<br>> <br>> Can you remind me, I think you figured out a way around the raster<br>> unpackaged issue so it works in PG 13 too so it should be possible for<br>> someone to go straight from say PG 9.x 2.4 to PG 13 3.x<br><br>I'm not sure what you're referring to.<br>The `CREATE FROM UNPACKAGED` syntax was removed from<br>postgis_extensions_upgrade()<br>in commit 520af0e8d1bb6e9544d974713bb87e428ff4230b<br>which seems to be both in 3.1 and 3.2 branches,<br>not sure it landed in 3.0 (there's no notice of it in the NEWS file)<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><u></u><u></u></p></blockquote></div></div></div></div>_______________________________________________<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>