<div dir="ltr">Hi Team,<div><br></div><div>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.</div><div><br></div><div>Error:</div><div><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><span style="color:rgb(255,0,0)">could not load library "$libdir/postgis-2.5": ERROR:  could not access file "$libdir/postgis-2.5": No such file or directory</span><br><br></p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Resolution: Create a symlink</p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">cd /usr/pgsql-13/lib<br>1) ln -s<span class="gmail-Apple-converted-space"> </span><a rel="nofollow" href="http://rtpostgis-2.4.so/" class="external-link" style="color:rgb(0,112,201);text-decoration:none">postgis-3.so</a><span class="gmail-Apple-converted-space"> </span><a rel="nofollow" href="http://rtpostgis-2.3.so/" class="external-link" style="color:rgb(0,112,201);text-decoration:none">postgis-2.5.so</a></p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Once symlink is created proceed with pg_upgrade and it is successful. I wanted to confirm whether this is the right way to go? </p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Note: We are not changing the symlink after pg_upgrade.</p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><br></p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Thanks,</p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Nikhil</p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><br></p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><br></p><p style="margin:10px 0px 0px;padding:0px;color:rgb(23,43,77);font-family:-apple-system,"SF Pro Text","SF Pro Icons","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><br></p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 28, 2022 at 5:44 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 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" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>