[postgis-users] ogr_fdw installation error

[Zwettler Markus (OIZ)]

Hi,

Seems to be an RHEL upgrade problem.

Our older installations are Postgres 9.6 + Postgis 2.4.

When I try to get the PostGIS Version there, I get the same error.

Any idea how to find out with versions are causing the problem?

Thanks, Markus




monitor at pcl_d016:pdb_d06_geo # select version();
                                                  version
-----------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
(1 row)

Time: 0.414 ms
monitor at pcl_d016:pdb_d06_geo # select PostGIS_Full_Version();
ERROR:  could not load library "/usr/pgsql-9.6/lib/rtpostgis-2.4.so": /usr/gdal30/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r
CONTEXT:  SQL statement "SELECT public.postgis_gdal_version()"
PL/pgSQL function postgis_full_version() line 33 at SQL statement
Time: 111.637 ms



postgres at szhm49251:/home/postgres pdb_d06_geo $ rpm -aq | grep postgres
postgresql96-contrib-9.6.17-1PGDG.rhel7.x86_64
postgresql96-libs-9.6.17-1PGDG.rhel7.x86_64
postgresql96-server-9.6.17-1PGDG.rhel7.x86_64
postgresql96-devel-9.6.17-1PGDG.rhel7.x86_64
postgresql96-9.6.17-1PGDG.rhel7.x86_64
postgresql96-plpython-9.6.17-1PGDG.rhel7.x86_64
postgres at szhm49251:/home/postgres pdb_d06_geo $ rpm -aq | grep postgis
postgis24_96-2.4.8-7.rhel7.x86_64
postgis24_96-client-2.4.8-7.rhel7.x86_64
postgres at szhm49251:/home/postgres pdb_d06_geo $ rpm -qa | grep gda
gdal-libs-1.11.4-12.rhel7.x86_64
gdal30-libs-3.0.4-1.rhel7.x86_64
gdal23-libs-2.3.2-8.rhel7.x86_64







> Date: Fri, 6 Mar 2020 14:18:06 +0100
> From: rmrodriguez at carto.com
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] ogr_fdw installation error
> Message-ID:
> 	<CAM6_UM7A8hRby=visrmASnfe2ccq=KDiH96473JSde1ew7AaGQ at mail.
> gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
> Hi,
> 
> It looks like you might be loading multiple versions of the same library (likely
> GEOS) at the same time. Please make sure that both Postgis and ogr_fdw are
> built against the exact same dependencies if you are going to use both in a single
> SQL session.
> 
> 
> On Fri, Mar 6, 2020 at 2:03 PM Zwettler Markus (OIZ)
> <Markus.Zwettler at zuerich.ch> wrote:
> >
> > Curios:
> >
> >
> >
> > 1. select PostGIS_Full_Version();
> >
> > 2. drop extension if exists ogr_fdw;
> >
> > 3. create extension ogr_fdw;               => everything fine
> >
> >
> >
> >
> >
> > 1. drop extension if exists ogr_fdw;
> >
> > 2. create extension ogr_fdw;             => ERROR:  could not load...
> >
> > 3. select PostGIS_Full_Version();        => server closed the connection
> unexpectedly...
> >
> >
> >
> > Details below.
> >
> >
> >
> > Any idea on this one?
> >
> >
> >
> > -Markus
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > $ psql
> >
> > monitor at pcl_l202:pdb_l22_oiz # drop extension if exists ogr_fdw;
> >
> > NOTICE:  extension "ogr_fdw" does not exist, skipping
> >
> > Time: 0.551 ms
> >
> > monitor at pcl_l202:pdb_l22_oiz # create extension ogr_fdw;
> >
> > ERROR:  could not load library "/usr/pgsql-12/lib/ogr_fdw.so":
> > /usr/gdal30/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r
> >
> > Time: 73.423 ms
> >
> > monitor at pcl_l202:pdb_l22_oiz # select PostGIS_Full_Version();
> >
> > server closed the connection unexpectedly
> >
> >         This probably means the server terminated abnormally
> >
> >         before or while processing the request.
> >
> > The connection to the server was lost. Attempting reset: Failed.
> >
> > Time: 1024.585 ms (00:01.025)
> >
> > @pcl_l202: > \q
> >
> > $ psql
> >
> > monitor at pcl_l202:pdb_l22_oiz # select PostGIS_Full_Version();
> >
> >
> > postgis_full_version
> >
> > ----------------------------------------------------------------------
> > ----------------------------------------------------------------------
> > ----------------------------------------------------------------------
> > -------
> >
> > POSTGIS="2.5.3 r17699" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1
> > " PROJ="Rel. 6.2.1, November 1st, 2019" GDAL="GDAL 3.0.4, released
> > 2020/01/28" LIBXML="2.9.1" LIBJSON="0.11" LIBPROTOBUF="1.0.2"
> TOPOLOGY
> > RASTER
> >
> > (1 row)
> >
> >
> >
> > Time: 159.242 ms
> >
> > monitor at pcl_l202:pdb_l22_oiz # drop extension if exists ogr_fdw;
> >
> > NOTICE:  extension "ogr_fdw" does not exist, skipping
> >
> > Time: 0.433 ms
> >
> > monitor at pcl_l202:pdb_l22_oiz # create extension ogr_fdw;
> >
> > Time: 6.024 ms
> >
> > monitor at pcl_l202:pdb_l22_oiz # select * from version();
> >
> >                                                  version
> >
> > ----------------------------------------------------------------------
> > -----------------------------------
> >
> > PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
> > 20150623 (Red Hat 4.8.5-39), 64-bit
> >
> > (1 row)
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> 
> 
> 
> --
> Raúl Marín Rodríguez
> carto.com
>