[postgis-users] Upgrading From PostGIS2.3.7 To PostGIS 3x

Regina Obe lr at pcorp.us
Thu Sep 8 00:09:27 PDT 2022

Apologies,  I think I misread the gcc as the Red hat edition.


If you run


cat /etc/redhat-release



that will tell you what version of Redhat you are running.  If you are running 7 or above then that is good.  Lower – not so good.


From: Regina Obe [mailto:lr at pcorp.us] 
Sent: Thursday, September 8, 2022 3:00 AM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
Subject: RE: [postgis-users] Upgrading From PostGIS2.3.7 To PostGIS 3x




As you wrote in IRC, you are running


POSTGIS="2.3.7 r16523" PGSQL="96" GEOS="3.10.3-CAPI-1.16.1" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER PostgreSQL 9.6.24 on x86_64-pc-linux-gnu,

compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit


Which is a very old Redhat.  I think that has reached End Of Life.  




yum list | grep postgis



If you see a postgis31 or postgis32, that’s a good start as it will tell you your upgrade options.


I for example have:


postgis24_10.x86_64                        2.4.9-3.rhel7          pgdg10


postgis32_14.x86_64                        3.2.3-1.rhel7          pgdg14



and a bunch of others.


Depending on what applications you are using, you may not want to go further up than PG 11 without testing your apps.


>From PG12 on, there were a bunch of breaking changes that caused some issues with pgsql drivers, often requiring some rewriting of logic.



From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Amine Tengilimoglu
Sent: Thursday, September 8, 2022 2:18 AM
To: postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
Subject: [postgis-users] Upgrading From PostGIS2.3.7 To PostGIS 3x


Hi everyone;


         I have postgres9.6 and postGIS2.3.7 installed on it. I need to get rid of version 9.6 now. I will upgrade it to pg13 at least but I didnt work with postgis before. I suppose firstly it is needed to upgrade postGIS.


          When I search how I upgrade postGIS2x to postGIS3x I didnt find reliable doc. How can I do this? and is it possible? I mean will there be a problem in the future, can an incompatibility problem occur?


          I will be waiting for your advices. Thanks in advence

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220908/635b502d/attachment.htm>

More information about the postgis-users mailing list