BUG #18153: Undefined Symbol creating postgis_raster extension

Started by PG Bug reporting formover 2 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 18153
Logged by: Andy Knight
Email address: knightaj1964@gmail.com
PostgreSQL version: 13.12
Operating system: Rocky 8.8
Description:

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

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: BUG #18153: Undefined Symbol creating postgis_raster extension

On Tue, 2023-10-10 at 12:02 +0000, PG Bug reporting form wrote:

PostgreSQL version: 13.12
Operating system:   Rocky 8.8
Description:       

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

This is not a PostgreSQL error; it looks like a packaging error.

Write to pgsql-pkg-yum@lists.postgresql.org

Yours,
Laurenz Albe