Обсуждение: 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
Вложения
AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -
От
"Lorenz, Christopher"
Дата:
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