upgrade pg from 11 to 16 and postgis

[Regina Obe]

I think the GDAL library is part of the pgdg-common lib.  I know in Centos 7
I used to manually add these to my yum repo list, but I thought for 8 and on
this was automatically done.

 

https://yum.postgresql.org/news/rocky-9-8-llvm-repo-is-available/

 

 

 

From: Bekir Niyaz <bagafoot at hotmail.com> 
Sent: Thursday, May 30, 2024 4:18 AM
To: Regina Obe <lr at pcorp.us>; postgis-users at lists.osgeo.org
Subject: Ynt: upgrade pg from 11 to 16 and postgis

 

Thank you  <mailto:lr at pcorp.us> @Regina Obe for your reply.

 

Even if I try install latest postgis version, getting the same dependency
errors

 



Full version the os after installation



  _____  

Gönderen: Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> >
Gönderildi: 29 Mayıs 2024 Çarşamba 16:59
Kime: 'Bekir Niyaz' <bagafoot at hotmail.com <mailto:bagafoot at hotmail.com> >;
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
<postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Konu: RE: upgrade pg from 11 to 16 and postgis 

 

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-
upgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html>
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 <mailto:bagafoot at hotmail.com> >
Sent: Wednesday, May 29, 2024 8:58 AM
To: postgis-users at lists.osgeo.org <mailto: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/20240530/7104b2cc/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 32028 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/7104b2cc/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 15757 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/7104b2cc/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 71785 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/7104b2cc/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 49718 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/7104b2cc/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 102095 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/7104b2cc/attachment-0004.png>