<div dir="ltr">Hi Regina,<div><br></div><div>I upgraded the existing PostGIS 3.1.2 to 3.3.5 on PG13 but now when I am trying to install PostGIS 3.3.5 for PG15 , I am getting below error</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Error: Transaction test error:</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64</span></p>
<br class="gmail-Apple-interchange-newline"></div><div>Do you know how we can resolve this ?</div><div><br></div><div><br></div><div>Complete install o/p</div><div><br></div><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"><span style="font-variant-ligatures:no-common-ligatures">yum install -y postgis33_15*<br></span><span style="font-variant-ligatures:no-common-ligatures">Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM UTC.<br></span><span style="font-variant-ligatures:no-common-ligatures">Dependencies resolved.<br></span><span style="font-variant-ligatures:no-common-ligatures">==============================================================================================================================================================================================================================<br></span><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>Package<span class="gmail-Apple-converted-space"> </span>Architecture<span class="gmail-Apple-converted-space"> </span>Version <span class="gmail-Apple-converted-space"> </span>Repository <span class="gmail-Apple-converted-space"> </span>Size<br></span><span style="font-variant-ligatures:no-common-ligatures">==============================================================================================================================================================================================================================<br></span><span style="font-variant-ligatures:no-common-ligatures">Installing:<br></span><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">postgis33_15 <span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures"> x86_64<span class="gmail-Apple-converted-space"> </span>3.3.5-1PGDG.rhel8 <span class="gmail-Apple-converted-space"> </span>@commandline<span class="gmail-Apple-converted-space"> </span>4.8 M<br></span><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">postgis33_15-client<span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures"> x86_64<span class="gmail-Apple-converted-space"> </span>3.3.5-1PGDG.rhel8 <span class="gmail-Apple-converted-space"> </span>@commandline<span class="gmail-Apple-converted-space"> </span>289 k<br></span><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">postgis33_15-devel <span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures"> x86_64<span class="gmail-Apple-converted-space"> </span>3.3.5-1PGDG.rhel8 <span class="gmail-Apple-converted-space"> </span>@commandline<span class="gmail-Apple-converted-space"> </span>8.3 k<br></span><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">postgis33_15-utils <span class="gmail-Apple-converted-space"> </span></span><span style="font-variant-ligatures:no-common-ligatures"> x86_64<span class="gmail-Apple-converted-space"> </span>3.3.5-1PGDG.rhel8 <span class="gmail-Apple-converted-space"> </span>@commandline <span class="gmail-Apple-converted-space"> </span>44 k</span><br><span style="font-variant-ligatures:no-common-ligatures">Transaction Summary</span><br><span style="font-variant-ligatures:no-common-ligatures">==============================================================================================================================================================================================================================</span><br><span style="font-variant-ligatures:no-common-ligatures">Install<span class="gmail-Apple-converted-space"> </span>4 Packages</span><br><span style="font-variant-ligatures:no-common-ligatures">Total size: 5.1 M</span><br><span style="font-variant-ligatures:no-common-ligatures">Installed size: 45 M</span><br><span style="font-variant-ligatures:no-common-ligatures">Downloading Packages:</span><br><span style="font-variant-ligatures:no-common-ligatures">Running transaction check</span><br><span style="font-variant-ligatures:no-common-ligatures">Transaction check succeeded.</span><br><span style="font-variant-ligatures:no-common-ligatures">Running transaction test</span><br><span style="font-variant-ligatures:no-common-ligatures">Error: Transaction test error:</span><br><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-converted-space"> </span>file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64</span></blockquote>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0);min-height:15px"><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:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0);min-height:15px"><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:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0);min-height:15px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
Thanks,</div><div>Nikhil</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 16, 2024 at 11:16 AM Nikhil Shetty <<a href="mailto:nikhil.dba04@gmail.com">nikhil.dba04@gmail.com</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 dir="ltr">Hi Regina,<div><br></div><div>We are upgrading from PG 13 3.1.2 to PG 15 3.3.5</div><div><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">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.</blockquote><div>pg_upgrade is checking in the PG13 lib whether the .so file exists or not. </div><div><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">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.</blockquote><div>We might have to go with this approach because it checks the .so file in old version</div><div><br></div><div><br></div><div>Error:</div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">pg_dump: error: query failed: ERROR:<span> </span>could not access file "$libdir/postgis-3": No such file or directory</font></span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">pg_dump: detail: Query was: EXECUTE dumpFunc('23873')</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p>Missing .so files:<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">-0-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-13/lib/postgis*</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">ls: cannot access '/usr/pgsql-13/lib/postgis*': No such file or directory</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif"><br></font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">-2-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-15/lib/postgis*</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(55,238,33)"><font face="verdana, sans-serif">/usr/pgsql-15/lib/postgis-3.so</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(55,238,33)"><font face="verdana, sans-serif">/usr/pgsql-15/lib/postgis_raster-3.so</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(55,238,33)"><font face="verdana, sans-serif">/usr/pgsql-15/lib/postgis_sfcgal-3.so</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="verdana, sans-serif">
</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(55,238,33)"><font face="verdana, sans-serif">/usr/pgsql-15/lib/postgis_topology-3.so</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p></div><div>Thanks,</div><div>Nikhil</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 16, 2024 at 10:53 AM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">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><div lang="EN-US"><div><p class="MsoNormal">Nikhil,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Which version of PostgreSQL are you upgrading from.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></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.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><div style="border-width:medium medium medium 1.5pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor blue;padding:0in 0in 0in 4pt"><div><div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(225,225,225) currentcolor currentcolor;padding:3pt 0in 0in"><p class="MsoNormal"><b>From:</b> Nikhil Shetty <<a href="mailto:nikhil.dba04@gmail.com" target="_blank">nikhil.dba04@gmail.com</a>> <br><b>Sent:</b> Thursday, February 15, 2024 11:37 PM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> GDAL dependencies during PostGIS upgrade<u></u><u></u></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 are planning to upgrade postgres to 15 and postgis from 3.1.2 to 3.3.5.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Below is the issue when installing gdal36 which is required for postgis 3.3.5<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentcolor currentcolor currentcolor rgb(204,204,204);padding:0in 0in 0in 6pt;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> </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><u></u><u></u></p></blockquote><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks,<u></u><u></u></p></div><div><p class="MsoNormal">Nikhil <u></u><u></u></p></div></div></div></div></div></div></blockquote></div>
</blockquote></div>