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

[Justin Pryzby]

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