<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;}
@font-face
{font-family:Menlo;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.gmail-apple-converted-space
{mso-style-name:gmail-apple-converted-space;}
span.m-6986441655312221892gmail-apple-converted-space
{mso-style-name:m_-6986441655312221892gmail-apple-converted-space;}
span.EmailStyle21
{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=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Removing shouldn’t be a problem as I never install those. I suspect it contains the commandline tools, not something postgresql needs to run. Those probably get installed in the system bin instead of the postgresql bin, which is why you can have only one of them.<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> Tuesday, February 20, 2024 11:33 PM<br><b>To:</b> Regina Obe <lr@pcorp.us><br><b>Cc:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: 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,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I tired installing the single package but still the same error<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><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>yum install -y postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64.rpm<br>Last metadata expiration check: 0:01:18 ago on Wed 21 Feb 2024 02:51:19 AM UTC.<br>Dependencies resolved.<br>==============================================================================================================================================================================================================================<br><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>==============================================================================================================================================================================================================================<br>Installing:<br><span class=gmail-apple-converted-space> </span><span style='color:#39C026'>postgis33_15-client<span class=gmail-apple-converted-space> </span></span> 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>Transaction Summary<br>==============================================================================================================================================================================================================================<br>Install<span class=gmail-apple-converted-space> </span>1 Package<br>Total size: 289 k<br>Installed size: 1.4 M<br>Downloading Packages:<br>Running transaction check<br>Transaction check succeeded.<br>Running transaction test<br>Error: Transaction test error:<br><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<o:p></o:p></p></blockquote><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;font-stretch: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;min-height:15px'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Alternatively just remove the postgis_33_13_client<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-- Will this create a problem with the existing installation of PostGIS?. I am asking because we are just installing the new packages for now and we will do the actual postgres upgrade during a downtime window<o:p></o:p></p><p style='margin:0in;font-stretch: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;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p class=MsoNormal>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal>Nikhil<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Feb 20, 2024 at 11:30 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</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'><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I’m guessing you can’t have both clients installed. Not sure what is in the client package. <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>What if you don’t do <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>yum install -y postgis_33_15*<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>But instead just <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>yum install -y postgis_33_15<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I’m guessing whatever that client is, they probably get installed in the same place, so you only need one of them.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Alternatively just remove the postgis_33_13_client<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div style='border:none;border-left:solid windowtext 1.5pt;padding:0in 0in 0in 4.0pt;border-color:currentcolor currentcolor currentcolor blue'><div><div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:currentcolor currentcolor'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b>From:</b> Nikhil Shetty <<a href="mailto:nikhil.dba04@gmail.com" target="_blank">nikhil.dba04@gmail.com</a>> <br><b>Sent:</b> Tuesday, February 20, 2024 12:07 PM<br><b>To:</b> Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>><br><b>Cc:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: GDAL dependencies during PostGIS upgrade<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi Regina,<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>Error: Transaction test error:</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span class=m-6986441655312221892gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>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><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Do you know how we can resolve this ?<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Complete install o/p<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>yum install -y postgis33_15*<br>Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM UTC.<br>Dependencies resolved.<br>==============================================================================================================================================================================================================================<br><span class=m-6986441655312221892gmail-apple-converted-space> </span>Package<span class=m-6986441655312221892gmail-apple-converted-space> </span>Architecture<span class=m-6986441655312221892gmail-apple-converted-space> </span>Version <span class=m-6986441655312221892gmail-apple-converted-space> </span>Repository <span class=m-6986441655312221892gmail-apple-converted-space> </span>Size<br>==============================================================================================================================================================================================================================<br>Installing:<br><span class=m-6986441655312221892gmail-apple-converted-space> </span><span style='color:#39C026'>postgis33_15 <span class=m-6986441655312221892gmail-apple-converted-space> </span></span> x86_64<span class=m-6986441655312221892gmail-apple-converted-space> </span>3.3.5-1PGDG.rhel8 <span class=m-6986441655312221892gmail-apple-converted-space> </span>@commandline<span class=m-6986441655312221892gmail-apple-converted-space> </span>4.8 M<br><span class=m-6986441655312221892gmail-apple-converted-space> </span><span style='color:#39C026'>postgis33_15-client<span class=m-6986441655312221892gmail-apple-converted-space> </span></span> x86_64<span class=m-6986441655312221892gmail-apple-converted-space> </span>3.3.5-1PGDG.rhel8 <span class=m-6986441655312221892gmail-apple-converted-space> </span>@commandline<span class=m-6986441655312221892gmail-apple-converted-space> </span>289 k<br><span class=m-6986441655312221892gmail-apple-converted-space> </span><span style='color:#39C026'>postgis33_15-devel <span class=m-6986441655312221892gmail-apple-converted-space> </span></span> x86_64<span class=m-6986441655312221892gmail-apple-converted-space> </span>3.3.5-1PGDG.rhel8 <span class=m-6986441655312221892gmail-apple-converted-space> </span>@commandline<span class=m-6986441655312221892gmail-apple-converted-space> </span>8.3 k<br><span class=m-6986441655312221892gmail-apple-converted-space> </span><span style='color:#39C026'>postgis33_15-utils <span class=m-6986441655312221892gmail-apple-converted-space> </span></span> x86_64<span class=m-6986441655312221892gmail-apple-converted-space> </span>3.3.5-1PGDG.rhel8 <span class=m-6986441655312221892gmail-apple-converted-space> </span>@commandline <span class=m-6986441655312221892gmail-apple-converted-space> </span>44 k<br>Transaction Summary<br>==============================================================================================================================================================================================================================<br>Install<span class=m-6986441655312221892gmail-apple-converted-space> </span>4 Packages<br>Total size: 5.1 M<br>Installed size: 45 M<br>Downloading Packages:<br>Running transaction check<br>Transaction check succeeded.<br>Running transaction test<br>Error: Transaction test error:<br><span class=m-6986441655312221892gmail-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<o:p></o:p></p></blockquote><p style='margin:0in;font-stretch: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;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Nikhil<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On Fri, Feb 16, 2024 at 11:16 AM Nikhil Shetty <<a href="mailto:nikhil.dba04@gmail.com" target="_blank">nikhil.dba04@gmail.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi Regina,<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>We are upgrading from PG 13 3.1.2 to PG 15 3.3.5<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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></blockquote><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>pg_upgrade is checking in the PG13 lib whether the .so file exists or not. <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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></blockquote><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>We might have to go with this approach because it checks the .so file in old version<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Error:<o:p></o:p></p></div><div><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>pg_dump: error: query failed: ERROR: could not access file "$libdir/postgis-3": No such file or directory</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>pg_dump: detail: Query was: EXECUTE dumpFunc('23873')</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Missing .so files:<o:p></o:p></p><p style='margin:0in'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>-0-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-13/lib/postgis*</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>ls: cannot access '/usr/pgsql-13/lib/postgis*': No such file or directory</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;color:black'> </span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:black'>-2-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-15/lib/postgis*</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:#37EE21'>/usr/pgsql-15/lib/postgis-3.so</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:#37EE21'>/usr/pgsql-15/lib/postgis_raster-3.so</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:#37EE21'>/usr/pgsql-15/lib/postgis_sfcgal-3.so</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Verdana",sans-serif;color:#37EE21'>/usr/pgsql-15/lib/postgis_topology-3.so</span><o:p></o:p></p><p style='margin:0in;font-stretch: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'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Nikhil<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On Fri, Feb 16, 2024 at 10:53 AM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Nikhil,<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Which version of PostgreSQL are you upgrading from.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div style='border:none;border-left:solid windowtext 1.5pt;padding:0in 0in 0in 4.0pt;border-color:currentcolor currentcolor currentcolor blue'><div><div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:currentcolor'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi Team,<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid windowtext 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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: <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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Nikhil <o:p></o:p></p></div></div></div></div></div></div></blockquote></div></blockquote></div></div></div></div></div></blockquote></div></div></div></body></html>