[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Upgrading From PostGIS2.3.7 To PostGIS 3x
From: "Regina Obe" <lr () pcorp ! us>
Date: 2022-09-08 7:09:27
Message-ID: 001f01d8c351$ef2b76c0$cd826440$ () pcorp ! us
[Download RAW message or body]
This is a multipart message in MIME format.
[Attachment #2 (multipart/alternative)]
This is a multipart message in MIME format.
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@pcorp.us]
Sent: Thursday, September 8, 2022 3:00 AM
To: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>
Subject: RE: [postgis-users] Upgrading From PostGIS2.3.7 To PostGIS 3x
Amine,
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.
Run
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@lists.osgeo.org] On Behalf Of Amine \
Tengilimoglu
Sent: Thursday, September 8, 2022 2:18 AM
To: postgis-users@lists.osgeo.org <mailto:postgis-users@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
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" \
vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Apologies, \
I think I misread the gcc as the Red hat edition.<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If you \
run<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>cat \
/etc/redhat-release<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div \
style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Regina Obe \
[mailto:lr@pcorp.us] <br><b>Sent:</b> Thursday, September 8, 2022 3:00 \
AM<br><b>To:</b> 'PostGIS Users Discussion' \
<postgis-users@lists.osgeo.org><br><b>Subject:</b> RE: [postgis-users] \
Upgrading From PostGIS2.3.7 To PostGIS 3x<o:p></o:p></span></p></div></div><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Amine,<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>As you wrote \
in IRC, you are running<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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,<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>compiled by \
gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Which is a \
very old Redhat. I think that has reached End Of Life. \
<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Run \
<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span style='font-size:16.0pt;font-family:"Lucida Console"'>yum list \
| grep postgis</span><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If you see a \
postgis31 or postgis32, that's a good start as it will tell you your upgrade \
options.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I for example \
have:<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal style='text-autospace:none'><span \
style='font-size:16.0pt;font-family:"Lucida \
Console";color:#FF4040'>postgis</span><span \
style='font-size:16.0pt;font-family:"Lucida \
Console"'>24_10.x86_64 \
2.4.9-3.rhel7 \
pgdg10<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>:<o:p></o:p></span></p><p \
class=MsoNormal style='text-autospace:none'><span \
style='font-size:16.0pt;font-family:"Lucida \
Console";color:#FF4040'>postgis</span><span \
style='font-size:16.0pt;font-family:"Lucida \
Console"'>32_14.x86_64 \
3.2.3-1.rhel7 \
pgdg14<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>and a bunch \
of others.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Depending on \
what applications you are using, you may not want to go further up than PG 11 without \
testing your apps.<o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>From PG12 on, \
there were a bunch of breaking changes that caused some issues with pgsql drivers, \
often requiring some rewriting of logic.<o:p></o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div \
style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div \
style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p \
class=MsoNormal><b><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span \
style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [<a \
href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] \
<b>On Behalf Of </b>Amine Tengilimoglu<br><b>Sent:</b> Thursday, September 8, 2022 \
2:18 AM<br><b>To:</b> <a \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> \
[postgis-users] Upgrading From PostGIS2.3.7 To PostGIS \
3x<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p \
class=MsoNormal>Hi everyone;<o:p></o:p></p><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> \
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.<o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> \
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?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p \
class=MsoNormal> I will be waiting for your \
advices. Thanks in advence<o:p></o:p></p></div></div></div></div></div></body></html>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic