RE: [postgis-users] postgis_raster undefined symbol error

This problem usually happens if for some reason you have two versions of GEOS installed and the older one is being loaded.

Might be a packaging issue. I’ve cc’d the pgsql-yum mailing list for guidance.

Thanks,

Regina

From: postgis-users <postgis-users-bounces(at)lists(dot)osgeo(dot)org> On Behalf Of Andy Knight via postgis-users
Sent: Tuesday, October 10, 2023 12:34 AM
To: postgis-users(at)lists(dot)osgeo(dot)org
Cc: Andy Knight <knightaj1964(at)gmail(dot)com>
Subject: [postgis-users] postgis_raster undefined symbol error

I'm trying to create a postgis_raster extension and I'm getting the following error:

CREATE EXTENSION postgis_raster;

ERROR: could not load library "/usr/pgsql-13/lib/postgis_raster-3.so": /usr/libspatialite50/lib/libspatialite.so.8: undefined symbol: GEOSHilbertCode_r

The instance is running on Rocky 8 linux details as below;:

NAME="Rocky Linux"

VERSION="8.8 (Green Obsidian)"

postgis31_13-utils-3.1.9-1.rhel8.x86_64

postgis31_13-devel-3.1.9-1.rhel8.x86_64

postgis31_13-client-3.1.9-1.rhel8.x86_64

postgis31_13-3.1.9-1.rhel8.x86_64

postgis31_13-docs-3.1.9-1.rhel8.x86_64

postgresql13-server-13.12-1PGDG.rhel8.x86_64