Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -

On Thu, 5 Mar 2020 at 14:27, Lorenz, Christopher <
Christopher(dot)Lorenz(at)zit-bb(dot)brandenburg(dot)de> wrote:

> Hi,
>
> I've also checked it on a fresh server and found the cause. The problem
> exists in the 9.6 repository, may lower versions are also affected.
>
> To reproduce you should only use the 9.6 repository on a fresh installed
> system:
> I installed the postgresql repository and modified
> /etc/yum.repos.d/pgdg-redhat-all.repo, so only pgdg96 is enabled.
> Then I installed postgresql using :
> yum install epel-release
> yum install postgis24_96 postgresql96-server
> After CREATE EXTENSION postgis; the error of undefined symbol appears.
>
> The root cause is, gdal23 needs ogdi. This package comes from epel in
> Version 3.2.0.-0.19.beta2
> In repo 10 an upward you have includes ogdi in Version 3.2.0-4.
> If I use the package ogdi from the repository of pgdg10 postgresql96 using
> postgis24 works fine with gdal23.
>
> We only enable one version of postgresql repository with our servers and
> don't have two or more versions available. If you use the default
> configuration you don’t have this problem. If you include the ogdi 3.2.0-4
> in pgdg96 repository it should work correct.
>
> Christopher
>
> -----Ursprüngliche Nachricht-----
> Von: Devrim Gündüz <devrim(at)gunduz(dot)org>
> Gesendet: Freitag, 28. Juni 2019 15:05
> An: Lorenz, Christopher <Christopher(dot)Lorenz(at)ZIT-BB(dot)Brandenburg(dot)de>; '
> pgsql-pkg-yum(at)lists(dot)postgresql(dot)org' <pgsql-pkg-yum(at)lists(dot)postgresql(dot)org>
> Betreff: Re: AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and
> postgis 2.4 -
>
>
> > 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.
>

I just tried this and still getting this error

/usr/gdal23/lib/libgdal.so: undefined reference to
`ecs_SetReportErrorFunction'

gdal23.x86_64 2.3.2-8.rhel7
@pgdg10
gdal23-devel.x86_64 2.3.2-8.rhel7
@pgdg10
gdal23-libs.x86_64 2.3.2-8.rhel7
@pgdg10

yum list installed | grep ogdi
ogdi.x86_64 3.2.0-0.19.beta2.el7 @epel
ogdi41.x86_64 4.1.0-2.rhel7
@pgdg10

It would appear that the version of ogdi being installed is not correct.

This is a clean build of a centos7 server

Dave

https://www.postgres.rocks