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 1qqBRH-008TOS-1d for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 10 Oct 2023 12:02:15 +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 1qqBRE-007S62-3q for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 10 Oct 2023 12:02:13 +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 1qqBRD-007S5q-Js for pgsql-pkg-yum@lists.postgresql.org; Tue, 10 Oct 2023 12:02:12 +0000 Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qqBRB-000wkP-ID for pgsql-pkg-yum@postgresql.org; Tue, 10 Oct 2023 12:02:11 +0000 Received: by mail-oa1-x31.google.com with SMTP id 586e51a60fabf-1e113555a47so3760367fac.2 for ; Tue, 10 Oct 2023 05:02:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pcorp-us.20230601.gappssmtp.com; s=20230601; t=1696939328; x=1697544128; darn=postgresql.org; h=content-language:thread-index:mime-version:message-id:date:subject :in-reply-to:references:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=wLwpFlh6mV+VOsjapKIaAQavzersLAnb2T0At49NOf4=; b=LYhG5ZHj3wUPuB6W4kKBQiFYtsElVX2nnI6XB2Cc7t2fcFK/JmLSUBNWImOlteTgiv B20ojBiPxOjvwJK4fJbF/5dJDVkgDftf32u87yYrKdd3Tt5WHDw1NinA/CtCnzADa/N5 fVwpxL/qahskY58pdK5BbRFQqQwIioBBY+uipk+sLWMnApJoSXpArl5Rdxzgxg/qe7f3 rWd9RhpiHwDLP4A8ZRDOuTZ7sddc9+tn0qn884U49lZ7CRtYZ4EkUGk5jAVhpndfF0BN ukgjkOpmQHOQGbrngkCo/qYpYy+/4izmARz5SHwJ3sJfjFw7vbW7RDcgYT6Es/0Wo8vC G93g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696939328; x=1697544128; h=content-language:thread-index:mime-version:message-id:date:subject :in-reply-to:references:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=wLwpFlh6mV+VOsjapKIaAQavzersLAnb2T0At49NOf4=; b=AsMwjGDoR9Q3knX2oeRCFxqj2y3/1GAVclTnLTlUd0h7WpsneK+TEdVHqv2oN3WJBM +c6I3QAv0NEBXz3ejoZTSFWrsnPKr6S7BVNqbM9OQy6lc5qIvdnjgML1sh94CYNnXjR6 MgSCSzaZLW9XsdWfIqU+Goaz0tzd/4lI9ZN8OLlqzc57BfyPq7ULFvp6pUI00WQQZSXm +Hdyw3/4IGptWUSvCl30FJ1RzU5+2VkyCJZDd0Ai4Tw2yCndnWXKIzwY6/5I2GusynsC 2gmt6g6dFCuyueJRP7W0gEEqFO0OFVAfQ2ZnyVEmcqpSyxTP2prVUuJ104r8ehtTDkm/ pBeA== X-Gm-Message-State: AOJu0YxLFutItSk+DZejJvlErkQ58d8sWJh3M3UB5PVWcDSG8Hfvsnpu WkPt3gb7SGfvJpqAPqDQz2lEEA== X-Google-Smtp-Source: AGHT+IF9QMhPJA8p3Ku5stWeildYXUTI6JqYawB7+nkyQ+sQCI9MBYtTPZ+GJiz6/BaZHY4IDu7M5A== X-Received: by 2002:a05:6870:2050:b0:1dd:67a6:ed75 with SMTP id l16-20020a056870205000b001dd67a6ed75mr20863339oad.44.1696939328442; Tue, 10 Oct 2023 05:02:08 -0700 (PDT) Received: from R (50-78-240-110-static.hfc.comcastbusiness.net. [50.78.240.110]) by smtp.gmail.com with ESMTPSA id p6-20020a0ce186000000b0065b0e724f83sm4655206qvl.6.2023.10.10.05.02.07 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 10 Oct 2023 05:02:08 -0700 (PDT) From: "Regina Obe" To: "'PostGIS Users Discussion'" Cc: "'Andy Knight'" , References: In-Reply-To: Subject: RE: [postgis-users] postgis_raster undefined symbol error Date: Tue, 10 Oct 2023 08:02:18 -0400 Message-ID: <000501d9fb71$9ee9f7f0$dcbde7d0$@pcorp.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0006_01D9FB50.17DA53C0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQKKCNdoZmYBtVrJ+BlHygTxo7CEOq7i0MWA Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0006_01D9FB50.17DA53C0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable 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 =20 ------=_NextPart_000_0006_01D9FB50.17DA53C0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

This problem usually happens = if for some reason you have two versions of GEOS installed=C2=A0 and the = older one is being loaded.

Might be a = packaging issue.=C2=A0 I=E2=80=99ve cc=E2=80=99d the pgsql-yum mailing = list for guidance.

 

Thanks,

Regina

 

From: = postgis-users <postgis-users-bounces@lists.osgeo.org> 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 = <knightaj1964@gmail.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": = /usr/libspatialite50/lib/libspatialite.so.8: undefined symbol: = GEOSHilbertCode_r

 <= /o:p>

The = instance is running on Rocky 8 linux details as below;:

NAME=3D"= ;Rocky Linux"

VERSION=3D&q= uot;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

 <= /o:p>

postgresql13= -server-13.12-1PGDG.rhel8.x86_64

 <= /o:p>

------=_NextPart_000_0006_01D9FB50.17DA53C0--