Postgis 3.5.3 packages include 3.6.0 files

From: Chris Sinjakli <sinjo(at)planetscale(dot)com>
To: pgsql-pkg-debian(at)lists(dot)postgresql(dot)org
Subject: Postgis 3.5.3 packages include 3.6.0 files
Date: 2025-09-08 17:11:31
Message-ID: CABz-y4+1qcFV-jKRHLhQCtREAk4du_5wtTcJU8GFqPHmroxtNw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello,

I'm currently using the 3.5.3 package from
https://apt-archive.postgresql.org/pub/repos/apt bookworm-pgdg-archive main
- specifically 3.5.3+dfsg-1~exp1.pgdg120+1 - and it seems like in the last
week, it has been updated with some files from the 3.6.0 release.

Trying to install the extension from that package results in this error:

postgres=> CREATE EXTENSION postgis;
ERROR: could not find function "ST_CoverageClean" in file
"/usr/lib/postgresql/17/lib/postgis-3.so"

Specifically, it looks like the package installs the SQL scripts and
control file from 3.6.0:

$ ls /usr/share/postgresql/17/extension/postgis--3.6.0.sql
/usr/share/postgresql/17/extension/postgis--3.6.0.sql

$ cat /usr/share/postgresql/17/extension/postgis-3.control
# postgis extension
comment = 'PostGIS geometry and geography spatial types and functions'
default_version = '3.6.0'
module_pathname = '$libdir/postgis-3'
relocatable = false

Is it possible that a bad version of the 3.5.3 package has been pushed and
overwritten the working one?

Cheers,
Chris

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2025-09-08 17:34:14 Re: Postgis 3.5.3 packages include 3.6.0 files
Previous Message apt.postgresql.org Repository Update 2025-09-08 10:45:45 timescaledb updated to version 2.22.0+dfsg-1.pgdg+1