From: | Tim Kempisty <timothy(dot)kempisty(at)noaa(dot)gov> |
---|---|
To: | Regina Obe <lr(at)pcorp(dot)us> |
Cc: | PostGIS Users Discussion <postgis-users(at)lists(dot)osgeo(dot)org>, Andy Knight <knightaj1964(at)gmail(dot)com>, pgsql-pkg-yum(at)postgresql(dot)org |
Subject: | Re: [postgis-users] postgis_raster undefined symbol error |
Date: | 2023-10-10 13:12:23 |
Message-ID: | CE86804E-536C-417C-BAD6-E5B6CA632197@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-yum |
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 <lr(at)pcorp(dot)us> 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 <postgis-users-bounces(at)lists(dot)osgeo(dot)org <mailto: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 <mailto:postgis-users(at)lists(dot)osgeo(dot)org>
> Cc: Andy Knight <knightaj1964(at)gmail(dot)com <mailto: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 <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
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim Gündüz | 2023-10-10 17:28:17 | Re: Dependencies for PostGIS 3.4 for PG v16 on Fedora 38 seem wrong |
Previous Message | Regina Obe | 2023-10-10 12:02:18 | RE: [postgis-users] postgis_raster undefined symbol error |