[postgis-users] ogr_fdw installation error

[Zwettler Markus (OIZ)]

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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200306/dde6efa6/attachment.html>