Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qqCXS-008Z1x-Fu for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 10 Oct 2023 13:12:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qqCXQ-007r85-BZ for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 10 Oct 2023 13:12:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qqCXP-007r7u-FY for pgsql-pkg-yum@lists.postgresql.org; Tue, 10 Oct 2023 13:12:41 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qqCXM-000xJg-PZ for pgsql-pkg-yum@postgresql.org; Tue, 10 Oct 2023 13:12:38 +0000 Received: by mail-oi1-x22c.google.com with SMTP id 5614622812f47-3af65455e7fso4305505b6e.3 for ; Tue, 10 Oct 2023 06:12:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=noaa.gov; s=google; t=1696943555; x=1697548355; darn=postgresql.org; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=vxjoc2WtgEKoB+hp/JcSlUfgl1lgEPyzJ1exjqS/xVE=; b=Rs8mvRpw4KjluTmwdX4w8LM9TN/WlhWKkJujDrfrKTqbHbMh9lwZi+BiiOokjEsJWb 10Ppzkhzy74oDZ+1CaV/7GK7ze9K9vDaSMqrBwp0Hc86bEpwvZiw9Alx73FCF6/jTUA9 yMMbUbKdjYndNhSQjriV/MpKHzgrE8Hq6BqtesxMzFBdL4b/zl9EIpX3AAfI72bOtmbZ H17YMYS5Rc6ayqQfs+99kBndfyD+CcVkQmamPhgjzTqZXzfzb8BRNURDhw4PfZCmLBiV rR2JTR3TOWSi8zhY9OzjqpvSWBUb/05BrYptcwjHnwsyqMkQFqWq65GEwQSvkq3r2nsf TQVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696943555; x=1697548355; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=vxjoc2WtgEKoB+hp/JcSlUfgl1lgEPyzJ1exjqS/xVE=; b=HUihn4sfrg2yyA3fE3vy+ZTBokEjdRFfAxm/EGxfEzu/Hl7hAnlSkrFgpl4dj8CupC Yhf4xPjvULkizmf4ng/K7qpy55dfGr/x9MP1S21uaARBpXhWjPbMKr/PP7KWA1J1wZsN yIgCNkpabBXXvagKkFbzKh/Hr9aS/h7pNY2g7SOPkV32ZBlnDMRxsPxgNF1Abxbw1AFl xwQeVDu0O2d28zGyQODAt2mRHgCCp7DeUCT4M9/a8NwfAF7BCmkVYCWtenUuKdLl25FY EA0bqbn9GAaAilnSN3EoF8bF2ajh07UEviq1yjbrUW218ADHEkVNyycBeAxB4lswJbxj f4pw== X-Gm-Message-State: AOJu0YypDfhUadEHOQlXwoNfL8YbSfYH5YUDoF1Q59k9S+Rpl3jrklTI HsgAsVvjeFtgFGAgkgL4VpJTWg== X-Google-Smtp-Source: AGHT+IGQSz195C98MxC+/VdJlsN1/dzvWcAwfgMWxjnLOzPQIJA+M7/hynyQQBGV7nMFKUlJjbX6rg== X-Received: by 2002:a54:4387:0:b0:3a4:2983:fae4 with SMTP id u7-20020a544387000000b003a42983fae4mr17530842oiv.16.1696943555477; Tue, 10 Oct 2023 06:12:35 -0700 (PDT) Received: from smtpclient.apple (pool-108-18-197-146.washdc.fios.verizon.net. [108.18.197.146]) by smtp.gmail.com with ESMTPSA id n7-20020a0c9d47000000b0065d0dcc28e3sm4774634qvf.73.2023.10.10.06.12.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 10 Oct 2023 06:12:34 -0700 (PDT) From: Tim Kempisty Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_3AA38305-6CD9-4BA0-8B19-1DAEE32B55C6" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.100.2.1.4\)) Subject: Re: [postgis-users] postgis_raster undefined symbol error Date: Tue, 10 Oct 2023 09:12:23 -0400 In-Reply-To: <000501d9fb71$9ee9f7f0$dcbde7d0$@pcorp.us> Cc: PostGIS Users Discussion , Andy Knight , pgsql-pkg-yum@postgresql.org To: Regina Obe References: <000501d9fb71$9ee9f7f0$dcbde7d0$@pcorp.us> X-Mailer: Apple Mail (2.3774.100.2.1.4) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_3AA38305-6CD9-4BA0-8B19-1DAEE32B55C6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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=E2=80=AFAM, Regina Obe wrote: >=20 > 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=E2=80=99ve cc=E2=80=99d the pgsql-yum = mailing list for guidance. > =20 > Thanks, > Regina > =20 > From: postgis-users > On Behalf Of Andy Knight = via postgis-users > Sent: Tuesday, October 10, 2023 12:34 AM > To: postgis-users@lists.osgeo.org = > Cc: Andy Knight > > Subject: [postgis-users] postgis_raster undefined symbol error > =20 > I'm trying to create a postgis_raster extension and I'm getting the = following error: > =20 > 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 > =20 > The instance is running on Rocky 8 linux details as below;: > NAME=3D"Rocky Linux" > VERSION=3D"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 > =20 > postgresql13-server-13.12-1PGDG.rhel8.x86_64 --Apple-Mail=_3AA38305-6CD9-4BA0-8B19-1DAEE32B55C6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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=E2=80=AFAM, 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=E2=80=99ve cc=E2=80=99d the pgsql-yum mailing list for = guidance.
 
Thanks,
Regina
 
From: postgis-users <postgis-users-bounce= s@lists.osgeo.org> On Behalf Of Andy Knight via = postgis-users
Sent: Tuesday, October 10, 2023 = 12:34 AM
To: postgis-users@lists.osgeo.or= g
Cc: Andy= Knight <knightaj1964@gmail.com>
<= b>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=3D"Rocky Linux"
VERSION=3D"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

= --Apple-Mail=_3AA38305-6CD9-4BA0-8B19-1DAEE32B55C6--