public inbox for [email protected]help / color / mirror / Atom feed
RE: [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]> 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 13:12 Tim Kempisty <[email protected]> parent: Regina Obe <[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-12 02:39 Devrim Gündüz <[email protected]> parent: Tim Kempisty <[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-12 10:51 Devrim Gündüz <[email protected]> parent: Devrim Gündüz <[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-12 13:07 Andy Knight <[email protected]> parent: 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-13 14:02 Devrim Gündüz <[email protected]> parent: Andy Knight <[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