[postgis-users] ogr_fdw installation error

[rmrodriguez at carto.com]

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