upgrade from 3.5.3 to 3.6.0: ERROR: could not find function "ST_CoverageClean

[Paul Ramsey]

The implication is that for some reason the package you have includes an
older version of postgis-3.so than it is advertising. And yet has SQL
scripts for the latest version.

Maybe see if that bears out?

strings /usr/lib/postgresql/17/lib/postgis-3.so | grep "3.5"

Given that most packagers will have packaged 3.6 with PgSQL 18, not PgSQL
17, I can imagine a fat finger error happening potentially.

P.

On Tue, Oct 21, 2025 at 9:38 AM Justin Pryzby <pryzby at telsasoft.com> wrote:

> We got this error after applying debian OS updates:
>
> 2025-10-21 10:37:20 upgrade postgresql-17-postgis-3-scripts:all
> 3.5.3+dfsg-1~exp1.pgdg120+1 3.6.0+dfsg-2.pgdg13+1
>
> ts=# \dx postgis
>   Name   | Version | Schema |                        Description
>
> ---------+---------+--------+------------------------------------------------------------
>  postgis | 3.5.3   | public | PostGIS geometry and geography spatial types
> and functions
>
> ts=# ALTER EXTENSION postgis UPDATE ;
> ERROR:  could not find function "ST_CoverageClean" in file
> "/usr/lib/postgresql/17/lib/postgis-3.so"
> ts=# SELECT postgis_extensions_upgrade();
> NOTICE:  Updating extension postgis 3.5.3
> ERROR:  could not find function "ST_CoverageClean" in file
> "/usr/lib/postgresql/17/lib/postgis-3.so"
> CONTEXT:  SQL statement "ALTER EXTENSION postgis UPDATE TO "ANY";ALTER
> EXTENSION postgis UPDATE TO "3.6.0""
> PL/pgSQL function postgis_extensions_upgrade(text) line 88 at EXECUTE
>
> ts=# SELECT * FROM pg_available_extensions WHERE name='postgis';
>   name   | default_version | installed_version |
> comment
>
> ---------+-----------------+-------------------+------------------------------------------------------------
>  postgis | 3.6.0           | 3.5.3             | PostGIS geometry and
> geography spatial types and functions
>
> ts=# SELECT * FROM pg_available_extension_versions WHERE name='postgis';
>   name   |  version   | installed | superuser | trusted | relocatable |
> schema | requires |                          comment
>
>
> ---------+------------+-----------+-----------+---------+-------------+--------+----------+------------------------------------------------------------
>  postgis | unpackaged | f         | t         | f       | f           |
>     |          | PostGIS geometry and geography spatial types and functions
>  postgis | 3.6.0      | f         | t         | f       | f           |
>     |          | PostGIS geometry and geography spatial types and functions
>  postgis | ANY        | f         | t         | f       | f           |
>     |          | PostGIS geometry and geography spatial types and functions
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20251021/5dd96f88/attachment.htm>