public inbox for [email protected]
help / color / mirror / Atom feedRE: [postgis-users] postgis_raster undefined symbol error
6+ messages / 4 participants
[nested] [flat]
* RE: [postgis-users] postgis_raster undefined symbol error
@ 2023-10-10 12:02 Regina Obe <[email protected]>
2023-10-10 13:12 ` Re: [postgis-users] postgis_raster undefined symbol error Tim Kempisty <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Regina Obe @ 2023-10-10 12:02 UTC (permalink / raw)
To: 'PostGIS Users Discussion' <[email protected]>; +Cc: 'Andy Knight' <[email protected]>; pgsql-pkg-yum
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]> On Behalf Of Andy Knight via postgis-users
Sent: Tuesday, October 10, 2023 12:34 AM
To: [email protected]
Cc: Andy Knight <[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": /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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [postgis-users] postgis_raster undefined symbol error
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
@ 2023-10-10 13:12 ` Tim Kempisty <[email protected]>
2023-10-12 02:39 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Tim Kempisty @ 2023-10-10 13:12 UTC (permalink / raw)
To: Regina Obe <[email protected]>; +Cc: PostGIS Users Discussion <[email protected]>; Andy Knight <[email protected]>; 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 <[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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [postgis-users] postgis_raster undefined symbol error
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
2023-10-10 13:12 ` Re: [postgis-users] postgis_raster undefined symbol error Tim Kempisty <[email protected]>
@ 2023-10-12 02:39 ` Devrim Gündüz <[email protected]>
2023-10-12 10:51 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2023-10-12 02:39 UTC (permalink / raw)
To: Tim Kempisty <[email protected]>; Regina Obe <[email protected]>; +Cc: PostGIS Users Discussion <[email protected]>; Andy Knight <[email protected]>; pgsql-pkg-yum
Hi,
On Tue, 2023-10-10 at 09:12 -0400, Tim Kempisty wrote:
> All of the latest packages for Rocky/RHEL8 on PGDG have dependency
> problems with PostGIS, GDAL, GEOS, and GDAL's python support
> packages.
I believe I fixed this issue. Please see 3.6.4-4 packages.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [postgis-users] postgis_raster undefined symbol error
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
2023-10-10 13:12 ` Re: [postgis-users] postgis_raster undefined symbol error Tim Kempisty <[email protected]>
2023-10-12 02:39 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
@ 2023-10-12 10:51 ` Devrim Gündüz <[email protected]>
2023-10-12 13:07 ` Re: [postgis-users] postgis_raster undefined symbol error Andy Knight <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2023-10-12 10:51 UTC (permalink / raw)
To: Tim Kempisty <[email protected]>; Regina Obe <[email protected]>; +Cc: PostGIS Users Discussion <[email protected]>; Andy Knight <[email protected]>; pgsql-pkg-yum
Hi,
On Thu, 2023-10-12 at 03:39 +0100, Devrim Gündüz wrote:
> I believe I fixed this issue. Please see 3.6.4-4 packages.
err. 3.6.4-5.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [postgis-users] postgis_raster undefined symbol error
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
2023-10-10 13:12 ` Re: [postgis-users] postgis_raster undefined symbol error Tim Kempisty <[email protected]>
2023-10-12 02:39 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
2023-10-12 10:51 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
@ 2023-10-12 13:07 ` Andy Knight <[email protected]>
2023-10-13 14:02 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Andy Knight @ 2023-10-12 13:07 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: Tim Kempisty <[email protected]>; Regina Obe <[email protected]>; PostGIS Users Discussion <[email protected]>; pgsql-pkg-yum
Thanks for all the support. I've updated the rpms to the recent 3.1.9-2 and
I'm now able to create the extension.
On Thu, 12 Oct 2023, 11:51 Devrim Gündüz, <[email protected]> wrote:
> Hi,
>
> On Thu, 2023-10-12 at 03:39 +0100, Devrim Gündüz wrote:
> > I believe I fixed this issue. Please see 3.6.4-4 packages.
>
> err. 3.6.4-5.
>
> Regards,
> --
> Devrim Gündüz
> Open Source Solution Architect, PostgreSQL Major Contributor
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [postgis-users] postgis_raster undefined symbol error
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
2023-10-10 13:12 ` Re: [postgis-users] postgis_raster undefined symbol error Tim Kempisty <[email protected]>
2023-10-12 02:39 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
2023-10-12 10:51 ` Re: [postgis-users] postgis_raster undefined symbol error Devrim Gündüz <[email protected]>
2023-10-12 13:07 ` Re: [postgis-users] postgis_raster undefined symbol error Andy Knight <[email protected]>
@ 2023-10-13 14:02 ` Devrim Gündüz <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Devrim Gündüz @ 2023-10-13 14:02 UTC (permalink / raw)
To: Andy Knight <[email protected]>; +Cc: Tim Kempisty <[email protected]>; Regina Obe <[email protected]>; PostGIS Users Discussion <[email protected]>; pgsql-pkg-yum
Hi,
On Thu, 2023-10-12 at 14:07 +0100, Andy Knight wrote:
> Thanks for all the support. I've updated the rpms to the recent 3.1.9-
> 2 and I'm now able to create the extension.
Thanks!
Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-10-13 14:02 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-10 12:02 RE: [postgis-users] postgis_raster undefined symbol error Regina Obe <[email protected]>
2023-10-10 13:12 ` Tim Kempisty <[email protected]>
2023-10-12 02:39 ` Devrim Gündüz <[email protected]>
2023-10-12 10:51 ` Devrim Gündüz <[email protected]>
2023-10-12 13:07 ` Andy Knight <[email protected]>
2023-10-13 14:02 ` Devrim Gündüz <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox