RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 - - Mailing list pgsql-pkg-yum

From Lorenz, Christopher
Subject RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -
Date
Msg-id 356ba5a1e3144d15ac3668474b58ad4e@ZIT-BB.Brandenburg.de
Whole thread Raw
Responses Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4-  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-pkg-yum
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




pgsql-pkg-yum by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Problem upgrading postgis25_11 on Fedora 29
Next
From: Greg Clough
Date:
Subject: Missing old version of RepMgr?