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@pcorp.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
I'm trying to create a postgis_raster extension and I'm getting the following error:
CREATE EXTENSION postgis_raster;
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