public inbox for [email protected]
help / color / mirror / Atom feedMissing postgis update path from 3.3.6 in package 3.4.2
3+ messages / 2 participants
[nested] [flat]
* Missing postgis update path from 3.3.6 in package 3.4.2
@ 2024-08-14 08:37 Svensson Peter <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Svensson Peter @ 2024-08-14 08:37 UTC (permalink / raw)
To: [email protected] <[email protected]>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Missing postgis update path from 3.3.6 in package 3.4.2
@ 2024-08-14 11:03 Zaid Shabbir <[email protected]>
parent: Svensson Peter <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Zaid Shabbir @ 2024-08-14 11:03 UTC (permalink / raw)
To: Svensson Peter <[email protected]>; +Cc: [email protected] <[email protected]>
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 <[email protected]>
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* SV: Missing postgis update path from 3.3.6 in package 3.4.2
@ 2024-08-14 11:15 Svensson Peter <[email protected]>
parent: Zaid Shabbir <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Svensson Peter @ 2024-08-14 11:15 UTC (permalink / raw)
To: Zaid Shabbir <[email protected]>; +Cc: [email protected] <[email protected]>
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 <[email protected]>
Skickat: den 14 augusti 2024 13:03
Till: Svensson Peter
Kopia: [email protected]
Ä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 <[email protected]<mailto:[email protected]>> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-14 11:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-14 08:37 Missing postgis update path from 3.3.6 in package 3.4.2 Svensson Peter <[email protected]>
2024-08-14 11:03 ` Zaid Shabbir <[email protected]>
2024-08-14 11:15 ` SV: Missing postgis update path from 3.3.6 in package 3.4.2 Svensson Peter <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox