<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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-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:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@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="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Nikhil,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Which version of PostgreSQL are you upgrading from.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I forget if pg_upgrade checks the old .so to see if it can still load it or if it only checks if the new .so it is expecting in the new cluster is still available.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If it doesn’t check the old to try to load the lib, dropping postgis-3.1.2 should work just fine.<o:p></o:p></p><p class=MsoNormal>Since 3.0, the .so file didn’t change, so pg_upgrading from say a PG 13 3.1.2 to a PG 15 3.3.5 should work just fine.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If it does check, I’d try upgrading to a newer PostGIS on your older cluster, doesn’t need to be the same, just one where the gdals are compatible.<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> Nikhil Shetty <nikhil.dba04@gmail.com> <br><b>Sent:</b> Thursday, February 15, 2024 11:37 PM<br><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br><b>Subject:</b> GDAL dependencies during PostGIS upgrade<o:p></o:p></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>We are planning to upgrade postgres to 15 and postgis from 3.1.2 to 3.3.5.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>While installing postgis 3.3.5 we found some dependency issues with gdal36, we were able to workaround by removing postgis 3.1.2 and gdal32 packages but for postgres upgrade we need both postgis (3.1.2 and 3.3.5) packages to be present.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Below is the issue when installing gdal36 which is required for postgis 3.3.5<o:p></o:p></p></div><div><p class=MsoNormal><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><span style='font-family:"Verdana",sans-serif;color:black'>-0-root@<host1>:/tmp # yum install gdal36-libs-3.6.4-6PGDG.rhel8.x86_64.rpm<br>Last metadata expiration check: 0:00:58 ago on Wed 31 Jan 2024 02:01:35 PM UTC.<br>Error:<span class=gmail-apple-converted-space> </span><br>Problem: problem with installed package gdal32-libs-3.2.3-1.rhel8.x86_64<br>- package gdal32-libs-3.2.3-1.rhel8.x86_64 requires libarmadillo.so.9()(64bit), but none of the providers can be installed<br>- package gdal32-libs-3.2.2-13.rhel8.x86_64 requires libarmadillo.so.9()(64bit), but none of the providers can be installed<br>- cannot install both armadillo-12.6.6-1.el8.x86_64 and armadillo-9.700.2-1.el8.x86_64<br>- cannot install both armadillo-9.700.2-1.el8.x86_64 and armadillo-12.6.6-1.el8.x86_64<br>- package gdal36-libs-3.6.4-6PGDG.rhel8.x86_64 requires libarmadillo.so.12()(64bit), but none of the providers can be installed<br>- conflicting requests<br>(try to add '—allowerasing' to command line to replace conflicting packages or '—skip-broken' to skip uninstallable packages or '—nobest' to use not only best candidate packages)</span><o:p></o:p></p></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal>Nikhil <o:p></o:p></p></div></div></div></div></body></html>