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

[Bo Guo]

Hi, Regina!  I solved the problem.

It turned out I missed the step of "Adds pgdg keys and main repo" as
referenced in
https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS3UbuntuPGSQLApt

Thank you again!

Bo

On Tue, Sep 5, 2023 at 5:52 AM Bo Guo <bo.guo at gisticinc.com> wrote:

> Hi, Regina!
>
> I do not know why the new stall Postgresql 14 with Postgis-3 on the newly
> built Ubuntu server 22.04 would have Postgis 3.2.0.  This was the command I
> used for the postgis install:
>    sudo apt install postgresql-14-postgis-3
>
> I went to the postgis folder (/usr/share/postgresql/14/extension) but
> could ONLY see files with version of 3.2.0 and lower.  So it appeared that
> the installation did not bring postgis to the 3.2.1 or above.  Please let
> me know alternative ways to install higher version.
>
> Cheers,
>
> Bo
>
>
> On Mon, Sep 4, 2023 at 5:06 PM Regina Obe <lr at pcorp.us> wrote:
>
>> Bo,
>>
>>
>>
>> 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.
>>
>>
>>
>> Thanks,
>>
>> Regina
>>
>>
>>
>> *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:
>>
>>
>>
>> ALTER EXTENSION "postgis" UPDATE;
>>
>>
>>
>> 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
>>
>>
>>
>>
>>
>> *Bo Guo**, PhD, PE*
>> President
>>
>> 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>*
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230905/2e21389a/attachment.htm>