Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -

Hi,

I've also checked it on a fresh server and found the cause. The problem exists in the 9.6 repository, may lower
versionsare also affected. 
 

To reproduce you should only use the 9.6 repository on a fresh installed system:
I installed the postgresql repository and modified /etc/yum.repos.d/pgdg-redhat-all.repo, so only pgdg96 is enabled. 
Then I installed postgresql using :
yum install epel-release
yum install postgis24_96 postgresql96-server
After CREATE EXTENSION postgis; the error of undefined symbol appears.

The root cause is, gdal23 needs ogdi. This package comes from epel in Version 3.2.0.-0.19.beta2
In repo 10 an upward you have includes ogdi in Version 3.2.0-4.
If I use the package ogdi from the repository of pgdg10 postgresql96 using postgis24 works fine with gdal23.

We only enable one version of postgresql repository with our servers and don't have two or more versions available. If
youuse the default configuration you don’t have this problem. If you include the ogdi 3.2.0-4 in pgdg96 repository it
shouldwork correct.
 

Christopher

-----Ursprüngliche Nachricht-----
Von: Devrim Gündüz <devrim@gunduz.org> 
Gesendet: Freitag, 28. Juni 2019 15:05
An: Lorenz, Christopher <Christopher.Lorenz@ZIT-BB.Brandenburg.de>; 'pgsql-pkg-yum@lists.postgresql.org'
<pgsql-pkg-yum@lists.postgresql.org>
Betreff: Re: AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -


> The issue with the undefined symbol still exists with current packages on our
> systems:
> 
> select PostGIS_Full_Version();
> FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden:
> /usr/gdal23/lib/libgdal.so.20: undefined symbol: ecs_SetReportErrorFunction
> KONTEXT:  SQL-Anweisung »SELECT public.postgis_gdal_version()«

I cannot reproduce this on CentOS 7 and Fedora 30:

postgres=# create extension postgis;
CREATE EXTENSION
postgres=# select PostGIS_Full_Version();
                                                                              
 postgis_full_version                                                         
                       
------------------------------------------------------------------------------
------------------------------------------------------------------------------
-----------------------
 POSTGIS="2.4.7 r17330" PGSQL="96" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel
. 4.9.3, 15 August 2016" GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.1"
 LIBJSON="0.11" RASTER
(1 row)

I'll setup a fresh machine and test again.