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

2023-09-05 Thread 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  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  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  *On Behalf
>> Of *Bo Guo
>> *Sent:* Monday, September 4, 2023 7:40 PM
>> *To:* PostGIS Users Discussion 
>> *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 *
>>
>> *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

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

2023-09-05 Thread Regina Obe 
Where did you get your ubuntu package.  Usually I get from apt.postgresql.org 
but I think for 14 the default for that is newer than 3.2 and even then 3.2.0 
and 3.2.1 are very old micros.

Latest micro for PostGIS 3.2 is postgis-3.2.5.

 

Did you run :

 

apt update && apt upgrade

 

before installing?

 

If that doesn’t help then it’s a packaging issue that you should talk with your 
packager group about.

 

 

 

From: postgis-users  On Behalf Of Bo Guo
Sent: Tuesday, September 5, 2023 8:53 AM
To: PostGIS Users Discussion 
Subject: Re: [postgis-users] ERROR: extension "postgis" has no update path from 
version "3.2.1" to version "3.2.0"

 

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 mailto: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 mailto:postgis-users-boun...@lists.osgeo.org> > On Behalf Of Bo Guo
Sent: Monday, September 4, 2023 7:40 PM
To: PostGIS Users Discussion mailto: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  

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

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

2023-09-05 Thread Bo Guo 
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  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  *On Behalf
> Of *Bo Guo
> *Sent:* Monday, September 4, 2023 7:40 PM
> *To:* PostGIS Users Discussion 
> *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 *
>
> *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