public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tim Kempisty <[email protected]>
To: Regina Obe <[email protected]>
Cc: PostGIS Users Discussion <[email protected]>
Cc: Andy Knight <[email protected]>
Cc: [email protected]
Subject: Re: [postgis-users] postgis_raster undefined symbol error
Date: Tue, 10 Oct 2023 09:12:23 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CACx5t2BCP1hUw7wr54UxHzaPFGr1dEzEEr5YNER8M0=KoA-yQg@mail.gmail.com>
	<[email protected]>

All of the latest packages for Rocky/RHEL8 on PGDG have dependency problems with PostGIS, GDAL, GEOS, and GDAL's python support packages.  The closest you will get to a working combination out of the box is postgis34 + gdal36, which both use geos312.  The other combinations are built against different versions of geos, which results in your error when trying to CREATE EXTENTSION postgis_raster.  Unfortunately, the gdal36-python-tools package depends on a conflicting python support package that doesn't have the right osgeo python modules in it.  So if you need something like gdal_calc.py in your stack, postgis34 + gdal36 is still broken.  AFAIK there is no combination of GDAL + PostGIS in this repo that currently works 100%.

My own workaround was to install proj and geos (including devel packages) from the PGDG repo, then build my own gdal and postgis from the source on github.  I used proj92 and geos312, but I imagine you can get it to work with your own preferred versions of proj and geos.

-Tim


> On Oct 10, 2023, at 8:02 AM, Regina Obe <[email protected]> wrote:
> 
> 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 <[email protected] <mailto:[email protected]>> On Behalf Of Andy Knight via postgis-users
> Sent: Tuesday, October 10, 2023 12:34 AM
> To: [email protected] <mailto:[email protected]>
> Cc: Andy Knight <[email protected] <mailto:[email protected]>>
> 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 <http://postgis_raster-3.so/>";: /usr/libspatialite50/lib/libspatialite.so <http://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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: [postgis-users] postgis_raster undefined symbol error
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox