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....@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....@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 <l...@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-boun...@lists.osgeo.org> *On >>> Behalf Of *Bo Guo >>> *Sent:* Monday, September 4, 2023 7:40 PM >>> *To:* PostGIS Users Discussion <postgis-users@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@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >> _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users