<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-1">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Texte brut Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.TextebrutCar
{mso-style-name:"Texte brut Car";
mso-style-priority:99;
mso-style-link:"Texte brut";
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="FR" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Bug fixes to the November 26 installation packages fixed the issue (<a href="https://redmine.postgresql.org/issues/5961#change-25154">https://redmine.postgresql.org/issues/5961#change-25154</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Today i can update my servers.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thank you.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FR">De :</span></b><span style="mso-fareast-language:FR"> Alain Benard
<br>
<b>Envoyé :</b> mercredi 25 novembre 2020 08:36<br>
<b>À :</b> 'postgis-users@lists.osgeo.org' <postgis-users@lists.osgeo.org><br>
<b>Objet :</b> Problem postgis 2.5 Centos 8 - postgis doesn't work<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi ,<o:p></o:p></p>
<p class="MsoNormal">In an other post I explained a problem with raster2pgsql on Centos 8 but in fact the problem is more important and update server postgis make ‘create extension postgis failed’.<o:p></o:p></p>
<p class="MsoNormal">So i reinstalled postgres / postgis from scratch on a virtual machine with centos and with this command (<a href="https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/">https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/</a>) :<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"> The principals commands are :<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf -y install
</span><a href="https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm">https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm</a><span style="color:black"><o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf -qy module disable postgresql<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf -y install
</span><a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm">https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm</a><span style="color:black"><o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf config-manager --set-enabled PowerTools<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black">dnf -y install postgis25_12 postgis25_12-docs postgis25_12-utils postgis25_12-client<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:70.8pt"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><b><span style="color:black">Two version of proj are installed</span></b><span style="color:black"> with the script (even if i erase proj before with '</span> dnf remove proj-*')<span style="color:black"> :<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"> dnf list installed |grep proj
<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"> proj.x86_64 6.3.2-4.el8 @epel<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"> proj72.x86_64 7.2.0-1.rhel8 @pgdg-common<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">On step 4 The result : I can't use 'CREATE EXTENSION POSTGIS' :
<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span style="color:black"> ERREUR: n'a pas pu charger la bibliothèque « /usr/pgsql-12/lib/rtpostgis-2.5.so » : /usr/gdal32/lib/libgdal.so.28: undefined symbol: GTIFGetGCSInfoEx<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">I don’t know if this list is the best for this problem but today this problem is not just mine ;
<b><u>i think nobody can install postgis 2.5 with postgres 12 on centos 8 with this repository</u></b>.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">Thank you for explaining.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:black">Alain.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>