Ynt: upgrade pg from 11 to 16 and postgis

[Bekir Niyaz]

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

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

[cid:a8d6ea54-3e9d-419e-8401-105699c56413]
Full version the os after installation
[cid:bf459230-87ab-4c2d-90fc-e859e31e7b19]
________________________________
Gönderen: Regina Obe <lr at pcorp.us>
Gönderildi: 29 Mayıs 2024 Çarşamba 16:59
Kime: 'Bekir Niyaz' <bagafoot at hotmail.com>; postgis-users at lists.osgeo.org <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



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



[cid:image001.png at 01DAB1AE.75883EA0]



Enabled repo list

[cid:image002.png at 01DAB1AE.75883EA0]



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

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



[cid:image003.png at 01DAB1AE.75883EA0]





Best regards.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 71785 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 49718 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 102095 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 32028 bytes
Desc: image.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 15757 bytes
Desc: image.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240530/af3fdd81/attachment-0004.png>