upgrade pg from 11 to 16 and postgis

[Regina Obe]

I think there is probably only one version of PostGIS 3 series that is
shipped with each major version of PostgreSQL on yum, which is fine.

 

Just go with 3.4.  The file names for 3 series regardless the minor doesn't
change and is always postgis-3.so and postgis_raster-3.so

 

As far as trying to install PostGIS 2.5, DO NOT,  just use the symlink
approach to fix as discussed here:

 

https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-u
pgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html

 

Hope that helps,

Regina

 

From: Bekir Niyaz <bagafoot at hotmail.com> 
Sent: Wednesday, May 29, 2024 8:58 AM
To: postgis-users at lists.osgeo.org
Subject: upgrade pg from 11 to 16 and postgis

 

Hello, 

Im trying to update pg11 to pg16 (and postgis from 2.5 to 3.3) but my server
oracle linux 7 which doesnt support pg16.

Then I upgraded ora linux to 8, but now pg repos doesnt support pg11.

Then I installed archive repo  (pgdg11-archive) to install pg11 binaries. It
is working well but upgrade os deleted all pg11 and related binaries
including postgis2.5

 

Now when I running pg_upgrade --check it says me there no postgis2.5
packages.  

In database: test

could not load library "$libdir/postgis-2.5": ERROR:  could not access file
"$libdir/postgis-2.5": No such file or directory

When I trying to install postgis getting

 



 

Enabled repo list



 

Q1 : how to solve dependency error, even there enabled epel repo?

Q2: why in below list doesnt exist postgis33_16.x86_64 packages ?

 



 

 

Best regards.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240529/788e8d05/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 71785 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240529/788e8d05/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 49718 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240529/788e8d05/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 102095 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240529/788e8d05/attachment-0002.png>