[postgis-users] Postgis 2.4 Error: undefined symbol: proj_crs_get_datum_ensemble

[Zwettler Markus (OIZ)]

Any idea why this happens?




# select version();
                                                  version
-----------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.21 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)

Time: 0.799 ms
# SELECT postgis_full_version() ;
ERROR:  could not load library "/usr/pgsql-9.6/lib/rtpostgis-2.4.so": /usr/gdal32/lib/libgdal.so.28: undefined symbol: proj_crs_get_datum_ensemble
CONTEXT:  SQL statement "SELECT public.postgis_gdal_version()"
PL/pgSQL function postgis_full_version() line 33 at SQL statement
Time: 107.647 ms


$ ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so | grep gdal
        libgdal.so.28 => /usr/gdal32/lib/libgdal.so.28 (0x00007f3915f34000)
$ ldd /usr/gdal32/lib/libgdal.so.28 | grep proj
        libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007fb368a4f000)


# find /usr -name libgeos\*
/usr/geos38/lib64/libgeos.so
/usr/geos38/lib64/libgeos_c.so
/usr/geos38/lib64/libgeos_c.so.1
/usr/geos38/lib64/libgeos-3.8.1.so
/usr/geos38/lib64/libgeos_c.so.1.13.3
/usr/geos39/lib64/libgeos-3.9.0.so
/usr/geos39/lib64/libgeos.so
/usr/geos39/lib64/libgeos_c.so
/usr/geos39/lib64/libgeos_c.so.1
/usr/geos39/lib64/libgeos_c.so.1.16.2
# find /usr -name libgdal\*
/usr/lib64/ogdi/libgdal.so
/usr/lib64/libgdal.so.1
/usr/lib64/libgdal.so.1.18.4
/usr/ogdi41/lib/ogdi/libgdal.so
/usr/gdal30/lib/libgdal.so.26
/usr/gdal30/lib/libgdal.so.26.0.4
/usr/gdal31/lib/libgdal.so.27
/usr/gdal31/lib/libgdal.so.27.0.3
/usr/gdal32/lib/libgdal.so.28
/usr/gdal32/lib/libgdal.so.28.0.1
# find /usr -name libproj\*
/usr/lib64/libproj.so.0
/usr/lib64/libproj.so.0.7.0
/usr/proj71/lib/libproj.so.19
/usr/proj71/lib/libproj.so.19.1.1
/usr/proj72/lib/libproj.so.19
/usr/proj72/lib/libproj.so.19.2.1


$ rpm -qa | grep postgis
postgis24_96-2.4.9-3.rhel7.x86_64
postgis24_96-client-2.4.9-3.rhel7.x86_64
$ rpm -qa | grep gdal
gdal31-libs-3.1.3-2.rhel7.x86_64
gdal32-libs-3.2.1-3.rhel7.x86_64
gdal30-libs-3.0.4-4.rhel7.x86_64
gdal-libs-1.11.4-3.el7.x86_64
$ rpm -qa |grep geos
geos38-3.8.1-2.rhel7.x86_64
geos39-3.9.0-1.rhel7.x86_64
$ rpm -qa | grep proj
proj71-7.1.1-3.rhel7.x86_64
proj-4.8.0-4.el7.x86_64
proj72-7.2.1-1.rhel7.x86_64


# uname -a
Linux szhm49251 3.10.0-1160.15.2.el7.x86_64 #1 SMP Thu Jan 21 16:15:07 EST 2021 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)