postgis 3.0.0 incompatibility with LLVM 15

From: Ярослав Минин <yarasphoen(at)gmail(dot)com>
To: pgsql-pkg-debian(at)lists(dot)postgresql(dot)org
Subject: postgis 3.0.0 incompatibility with LLVM 15
Date: 2025-09-17 09:00:20
Message-ID: CALgcmnBPLB1img8R7V=mgjsLeV0qw00efYVot0hymE9Y1oZZHg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello!

Versions:
OS: Ubuntu 22.04

PostgreSQL 15.3 (Ubuntu 15.3-1.pgdg22.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit

POSTGIS="3.6.0 4c1967d" [EXTENSION] PGSQL="150" GEOS="3.10.2-CAPI-1.16.0"
SFCGAL="SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ="8.2.1
NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"
(compiled against PROJ 8.2.1) GDAL="GDAL 3.4.1, released 2021/12/27" LIBXML=
"2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" RASTER

After upgrading PostGIS from 3.3.0 to 3.6.0 (latest) most of our queries
result in the following error:
*error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')*
.

PostGIS was installed using *sudo apt-get install postgis
postgresql-15-postgis-3*.

It seems the problem is JIT using LLVM 14. LLVM on my PostgreSQL instance
is *'LLVM_CONFIG=/usr/bin/llvm-config-15'*.

Setting JIT=off solves the problem but we have quite many scenarios where
using JIT is let’s say prefferable.

So the question is is it possible to make PostGIS 3.3.0 compatible with my
PostgreSQL with JIT on?

--
Sincerely,
Yaras

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Yaroslav Minin 2025-09-17 09:36:07 postgis 3.0.0 incompatibility with LLVM 15
Previous Message apt.postgresql.org Repository Update 2025-09-15 15:37:33 pg-squeeze updated to version 1.9.1-1.pgdg+1