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) <[email protected]> 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@pcl_l202:pdb_l22_oiz # drop extension if exists ogr_fdw; > > NOTICE: extension "ogr_fdw" does not exist, skipping > > Time: 0.551 ms > > monitor@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@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@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@pcl_l202:pdb_l22_oiz # drop extension if exists ogr_fdw; > > NOTICE: extension "ogr_fdw" does not exist, skipping > > Time: 0.433 ms > > monitor@pcl_l202:pdb_l22_oiz # create extension ogr_fdw; > > Time: 6.024 ms > > monitor@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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users -- Raúl Marín Rodríguez carto.com _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
