Thread: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -
Hi, since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our RHEL7 enviroment we have trouble with the gdallibrary. There migth be a bug or something. The Problem also appears with PostgreSQL 10. If we call Postgis_Full_Version() we get the folowing error: FEHLER: konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: libgdal.so.20: Kann die Shared-Object-Dateinicht öffnen: Datei oder Verzeichnis nicht gefunden (english: can't load libgdal.so.20 - File not found) So I've checked the sharded libraries: ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so linux-vdso.so.1 => (0x00007fffabb87000) libgdal.so.20 => not found .... During the last update the new package was installed: gdal23-libs.x86_64 2.3.2-7.rhel7 postgis24_96.x86_64 2.4.7-3.rhel7 but the path was not in librarypath, so I added it manualy: echo '/usr/gdal23/lib/' > /etc/ld.so.conf.d/fix-pgdg-gdal.conf ldconfig ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so | grep gdal libgdal.so.20 => /usr/gdal23/lib/libgdal.so.20 (0x00007fecad2c8000) Now I restartet the server but there is something more: 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 Is it a bug or misconfiguration myself? When I downgrad to postgis24_96-2.4.6-4.rhel7.x86_64, everthing works fine, postgris uses 1.11 Regards, Christopher Lorenz
Hi, On Tue, 2019-06-25 at 09:34 +0000, Lorenz, Christopher wrote: > since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our > RHEL7 enviroment we have trouble with the gdal library. There migth be a bug > or something. The Problem also appears with PostgreSQL 10. > > If we call Postgis_Full_Version() we get the folowing error: > > FEHLER: konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: > libgdal.so.20: Kann die Shared-Object-Datei nicht öffnen: Datei oder > Verzeichnis nicht gefunden > (english: can't load libgdal.so.20 - File not found) I pushed gdal23 2.3.2-8 package to repositories, which fixes this issue. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -
From
"Lorenz, Christopher"
Date:
Hi Devrim, Updating the packages to gdal23-libs-2.3.2-8 and postgis24_96-2.4.7-4 solved the problem with the missing library/ldconfig. 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()« Regards, Christopher Lorenz -----Ursprüngliche Nachricht----- Von: Devrim Gündüz <devrim@gunduz.org> Gesendet: Donnerstag, 27. Juni 2019 20:34 An: Lorenz, Christopher <Christopher.Lorenz@ZIT-BB.Brandenburg.de>; 'pgsql-pkg-yum@lists.postgresql.org' <pgsql-pkg-yum@lists.postgresql.org> Betreff: Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 - Hi, On Tue, 2019-06-25 at 09:34 +0000, Lorenz, Christopher wrote: > since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our > RHEL7 enviroment we have trouble with the gdal library. There migth be a bug > or something. The Problem also appears with PostgreSQL 10. > > If we call Postgis_Full_Version() we get the folowing error: > > FEHLER: konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: > libgdal.so.20: Kann die Shared-Object-Datei nicht öffnen: Datei oder > Verzeichnis nicht gefunden > (english: can't load libgdal.so.20 - File not found) I pushed gdal23 2.3.2-8 package to repositories, which fixes this issue. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Hi Christopher, On Fri, 2019-06-28 at 10:12 +0000, Lorenz, Christopher wrote: > Updating the packages to gdal23-libs-2.3.2-8 and postgis24_96-2.4.7-4 solved > the problem with the missing library/ldconfig. Great! > 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. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR