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

[Gandalf the Gray]

Hi guys

Sorry to hijack this thread a bit, but my question is very similar.

Is it possible to use PostGIS from the postgresql apt repo, while using
gdal etc (for qgis and grass) from ubuntugis-unstable ppa?

Pieter

On Tue, Sep 5, 2023 at 4:00 PM Bo Guo <bo.guo at gisticinc.com> wrote:

> 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
>>>
>> _______________________________________________
> 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/20230906/8c239a96/attachment.htm>