[postgis-users] ERROR: extension "postgis" has no update path from version "3.2.1" to version "3.2.0"

Regina Obe lr at pcorp.us
Mon Sep 4 17:06:21 PDT 2023



At a glance, it looks like maybe your PostgreSQL 13 had a 3.2.1 installed and your PostgreSQL 14 has 3.2.0 installed (or at least the postgis.control file probably has 3.2.0 instead of 3.2.1).

I’d double check to make sure you did install 3.2.1 on your PostgreSQL 14.  Downgrades are not supported which is essentially what it’s telling you.



That said, the preferable way for upgrading PostGIS 3 is to use:


SELECT postgis_extensions_upgrade();


Though that will probably result in the same error since it seems your PostgreSQL 14 is running with 3.2.0 instead of 3.2.1.


The ALTER EXTENSION approach has a couple of downsides, that postgis_extensions_upgrade can handle


1.	It will only update postgis and not your other extensions like for example your postgis_topology.  Postgis_extensions_upgrade()  will upgrade any postgis_ extension.
2.	If you are moving from a PostgreSQL major to another PostgreSQL major on same version, you still need to upgrade, but because  ALTER EXTENSION relies on a version bump, it won’t be able to upgrade.


If you still see a mismatch after please let us know.  I know we’ve made improvements in postgis_extensions_upgrade so 3.2.0 might not have all the new features.





From: postgis-users <postgis-users-bounces at lists.osgeo.org> On Behalf Of Bo Guo
Sent: Monday, September 4, 2023 7:40 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [postgis-users] ERROR: extension "postgis" has no update path from version "3.2.1" to version "3.2.0"


Hi all,


I do not know how it happened, but after I upgraded from Postgresql 13- 14, I had a problem updating extensions, including postgis by using: 




Here is the version info:


SELECT version();

PostgreSQL 14.9 (Ubuntu 14.9-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit


SELECT postgis_full_version();

POSTGIS="3.2.0 c3e3cc0" [EXTENSION] PGSQL="130" (procs need upgrade for use with PostgreSQL "140") GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.1" LIBXML="2.9.12" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" (core procs from "3.2.1 5fae8e5" need upgrade) TOPOLOGY (topology procs from "3.2.1 5fae8e5" need upgrade)


I really appreciate any help you can provide.





Bo Guo, PhD, PE
2820 S Alma School Rd #18-671, Chandler, AZ 85286

p 480-656-9962     c 602-570-4697
www.gisticinc.com <http://www.gisticinc.com> 

youtube.com/linearbench <http://youtube.com/linearbench> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230904/f926d6b2/attachment.htm>

More information about the postgis-users mailing list