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 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)

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