<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=iso-8859-9"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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><span style='font-size:11.0pt'>I think the GDAL library is part of the pgdg-common lib. I know in Centos 7 I used to manually add these to my yum repo list, but I thought for 8 and on this was automatically done.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><a href="https://yum.postgresql.org/news/rocky-9-8-llvm-repo-is-available/">https://yum.postgresql.org/news/rocky-9-8-llvm-repo-is-available/</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></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><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Bekir Niyaz <bagafoot@hotmail.com> <br><b>Sent:</b> Thursday, May 30, 2024 4:18 AM<br><b>To:</b> Regina Obe <lr@pcorp.us>; postgis-users@lists.osgeo.org<br><b>Subject:</b> Ynt: upgrade pg from 11 to 16 and postgis<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>Thank you <a id=OWAAM322651 href="mailto:lr@pcorp.us"><span style='font-family:"Calibri",sans-serif;text-decoration:none'>@Regina Obe</span></a> for your reply.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>Even if I try install latest postgis version, getting the same dependency errors<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'><img border=0 width=1200 height=141 style='width:12.5in;height:1.4687in' id="image_0" src="cid:image004.png@01DAB287.80D78CF0"></span><span style='font-family:"Calibri",sans-serif;color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>Full version the os after installation<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'><img border=0 width=485 height=209 style='width:5.052in;height:2.177in' id="Picture_x0020_2" src="cid:image005.png@01DAB287.80D78CF0"></span><span style='font-family:"Calibri",sans-serif;color:black'><o:p></o:p></span></p></div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><div id=divRplyFwdMsg><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>Gönderen:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'> Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>><br><b>Gönderildi:</b> 29 Mayıs 2024 Çarşamba 16:59<br><b>Kime:</b> 'Bekir Niyaz' <<a href="mailto:bagafoot@hotmail.com">bagafoot@hotmail.com</a>>; <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Konu:</b> RE: upgrade pg from 11 to 16 and postgis</span> <o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div></div><p><span style='font-size:11.0pt'>I think there is probably only one version of PostGIS 3 series that is shipped with each major version of PostgreSQL on yum, which is fine.</span><o:p></o:p></p><p><span style='font-size:11.0pt'> </span><o:p></o:p></p><p><span style='font-size:11.0pt'>Just go with 3.4. The file names for 3 series regardless the minor doesn’t change and is always postgis-3.so and postgis_raster-3.so</span><o:p></o:p></p><p><span style='font-size:11.0pt'> </span><o:p></o:p></p><p><span style='font-size:11.0pt'>As far as trying to install PostGIS 2.5, DO NOT, just use the symlink approach to fix as discussed here:</span><o:p></o:p></p><p><span style='font-size:11.0pt'> </span><o:p></o:p></p><p><u><span style='font-size:11.0pt;color:#467886'><a href="https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-upgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html"><span style='color:#467886'>https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-upgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html</span></a></span></u><o:p></o:p></p><p><span style='font-size:11.0pt'> </span><o:p></o:p></p><p><span style='font-size:11.0pt'>Hope that helps,</span><o:p></o:p></p><p><span style='font-size:11.0pt'>Regina</span><o:p></o:p></p><p><span style='font-size:11.0pt'> </span><o:p></o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Bekir Niyaz <<a href="mailto:bagafoot@hotmail.com">bagafoot@hotmail.com</a>><br><b>Sent:</b> Wednesday, May 29, 2024 8:58 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> upgrade pg from 11 to 16 and postgis</span><o:p></o:p></p></div><p> <o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Hello, </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Im trying to update pg11 to pg16 (and postgis from 2.5 to 3.3) but my server oracle linux 7 which doesnt support pg16.</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Then I upgraded ora linux to 8, but now pg repos doesnt support pg11.</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Then I installed archive repo (pgdg11-archive) to install pg11 binaries. It is working well but upgrade os deleted all pg11 and related binaries including postgis2.5</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Now when I running pg_upgrade --check it says me there no postgis2.5 packages. </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black;background:yellow'>In database: test</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black;background:yellow'>could not load library "$libdir/postgis-2.5": ERROR: could not access file "$libdir/postgis-2.5": No such file or directory</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>When I trying to install postgis getting</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:white'><img border=0 width=1344 height=292 style='width:14.0in;height:3.0416in' id="x_image_0" src="cid:image006.png@01DAB287.80D78CF0"></span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Enabled repo list</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'><img border=0 width=1685 height=256 style='width:17.552in;height:2.6666in' id="x_image_1" src="cid:image007.png@01DAB287.80D78CF0"></span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black;background:yellow'>Q1 : how to solve dependency error, even there enabled epel repo?</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black;background:yellow'>Q2: why in below list doesnt exist postgis33_16.x86_64 packages ?</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'><img border=0 width=747 height=459 style='width:7.7812in;height:4.7812in' id="x_image_2" src="cid:image008.png@01DAB287.80D78CF0"></span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'>Best regards.</span><o:p></o:p></p><p><span style='font-family:"Calibri",sans-serif;color:black'> </span><o:p></o:p></p></div></div></div></body></html>