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