Postgres Pro
Downloads
Home   >   mailing lists

Thread: Missing postgis update path from 3.3.6 in package 3.4.2

Missing postgis update path from 3.3.6 in package 3.4.2

From
Svensson Peter
Date:

Hi,


Then tried to update postgis extension, but got error:

   extension "postgis" has no update path from version "3.3.6" to version "3.4.2"

Name        : postgis34_14
Version     : 3.4.2
Release     : 3PGDG.rhel9

rpm -qpl postgis34_15-3.4.2-3PGDG.rhel9.x86_64.rpm  |grep extension          shows no  3.3.6  files/links, but exists for and older 3.3 versions.


Also missing in package   postgis34_15 and postgis34_16






Regards
Peter

Re: Missing postgis update path from 3.3.6 in package 3.4.2

From
Zaid Shabbir
Date:
Hello Svensson,

Can you please explain your problem a little? As per my understanding you are using PostgreSQL 14 with Postgis 3.3.6 and want to upgrade to 3.4.2 with the same PostgreSQL 14 version ?


Regards,
Zaid

On Wed, Aug 14, 2024 at 1:37 PM Svensson Peter <peter.svensson@smhi.se> wrote:

Hi,


Then tried to update postgis extension, but got error:

   extension "postgis" has no update path from version "3.3.6" to version "3.4.2"

Name        : postgis34_14
Version     : 3.4.2
Release     : 3PGDG.rhel9

rpm -qpl postgis34_15-3.4.2-3PGDG.rhel9.x86_64.rpm  |grep extension          shows no  3.3.6  files/links, but exists for and older 3.3 versions.


Also missing in package   postgis34_15 and postgis34_16






Regards
Peter

SV: Missing postgis update path from 3.3.6 in package 3.4.2

From
Svensson Peter
Date:

Yes,

I have PostreSQL 14 and  Postgis 3.3.6 installed and then installed the Postgis 3.4.2 rpm.

Then when doing     SELECT PostGIS_Extensions_Upgrade()   I got error.

There should be symbolic links named with  3.3.6  in  /usr/pgsql-<version>/share/extension/    
but they are missing.

I locally added the links, and then verified that the Extension upgrade succeed.

lrwxrwxrwx. 1 root root 44 Jun  3 10:19 /usr/pgsql-14/share/extension/address_standardizer--3.3.6--ANY.sql -> address_standardizer--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 52 Jun  3 10:19 /usr/pgsql-14/share/extension/address_standardizer_data_us--3.3.6--ANY.sql -> address_standardizer_data_us--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 38 Jun  3 10:19 /usr/pgsql-14/share/extension/postgis_sfcgal--3.3.6--ANY.sql -> postgis_sfcgal--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 38 Jun  3 10:20 /usr/pgsql-14/share/extension/postgis_raster--3.3.6--ANY.sql -> postgis_raster--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 40 Jun  3 10:20 /usr/pgsql-14/share/extension/postgis_topology--3.3.6--ANY.sql -> postgis_topology--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 31 Jun  3 10:20 /usr/pgsql-14/share/extension/postgis--3.3.6--ANY.sql -> postgis--TEMPLATED--TO--ANY.sql
lrwxrwxrwx. 1 root root 46 Jun  3 10:20 /usr/pgsql-14/share/extension/postgis_tiger_geocoder--3.3.6--ANY.sql -> postgis_tiger_geocoder--TEMPLATED--TO--ANY.sql

So this symlinks are missing in the RPM.

Regards,
Peter



Från: Zaid Shabbir <zaidshabbir@gmail.com>
Skickat: den 14 augusti 2024 13:03
Till: Svensson Peter
Kopia: pgsql-pkg-yum@lists.postgresql.org
Ämne: Re: Missing postgis update path from 3.3.6 in package 3.4.2
 
Hello Svensson,

Can you please explain your problem a little? As per my understanding you are using PostgreSQL 14 with Postgis 3.3.6 and want to upgrade to 3.4.2 with the same PostgreSQL 14 version ?


Regards,
Zaid

On Wed, Aug 14, 2024 at 1:37 PM Svensson Peter <peter.svensson@smhi.se> wrote:

Hi,


Then tried to update postgis extension, but got error:

   extension "postgis" has no update path from version "3.3.6" to version "3.4.2"

Name        : postgis34_14
Version     : 3.4.2
Release     : 3PGDG.rhel9

rpm -qpl postgis34_15-3.4.2-3PGDG.rhel9.x86_64.rpm  |grep extension          shows no  3.3.6  files/links, but exists for and older 3.3 versions.


Also missing in package   postgis34_15 and postgis34_16






Regards
Peter