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