<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:Consolas;
panose-1:2 11 6 9 2 2 4 3 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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
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.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>FWIW PostgreSQL 12 and 2.5 are not commonly used together aside from pg_upgrade from a lower PostGIS.<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'>So general use is install 2.5 (so that you can pg_upgrade a PostgreSQL 11 or higher to 12) and then install PostGIS 3.0 or higher.<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'>We had backported support for 12 in 2.5 because it was a big leap (e.g. we dropped the minor in our lib file, and we split out raster from postgis extension). So that is the only reason you see it supported in 2.5.<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'>So really it would be 9.4-11 (for 2.5) you should consider and 11 is going to be EOL’d in November 2023 (just a year from now).<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'> Vicky Vergara [mailto:vicky@georepublic.de] <br><b>Sent:</b> Friday, June 10, 2022 2:27 PM<br><b>To:</b> Esteban Zimanyi <estebanzimanyi@gmail.com><br><b>Cc:</b> Regina Obe <lr@pcorp.us>; mobilitydb-dev@lists.osgeo.org<br><b>Subject:</b> Re: Help with installation of PostGIS on a brand new machine<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Looking around:<br>PostGIS 2.5 goes up to PostgreSQL 12<o:p></o:p></span></p></div><p class=MsoNormal><a href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS" target="_blank">https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS</a><o:p></o:p></p><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Arial",sans-serif'>Trying to use PostGIS 2.5 on something above PostgreSQL 12 that I would consider it as a "use it at your own risk" situation.<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Arial",sans-serif'>The min version of a package can always be handled.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>How much effort to put on MobilityDB for PostGIS 2.5 goes up to PostgreSQL 12 until the EOL of PostgreSQL 12 on November 14, 2024?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>On the other hand, Using the min version of PostGIS 3.1, covers from Postgres 10 up to the postgres 14 (current)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Things that can be done:<br>For example, one of the reasons of creating a new repo for VRP problems is the postgres version (because of the new goodies that are used internally):<br><a href="https://github.com/pgRouting/vrprouting/blob/main/CMakeLists.txt#L54" target="_blank">https://github.com/pgRouting/vrprouting/blob/main/CMakeLists.txt#L54</a><br>So vrprouting can not be build on postgres 11 or 10<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>For building vrprouting do not need PostGIS, so we do not have a min version for that one.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Note that for installing postgis the minor version is omitted on ubuntu starting from version 3.0:<br><a href="https://www.ubuntuupdates.org/package/postgresql/xenial-pgdg/main/base/postgresql-13-postgis-3" target="_blank">https://www.ubuntuupdates.org/package/postgresql/xenial-pgdg/main/base/postgresql-13-postgis-3</a><o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Arial",sans-serif'>The policy on doing that will depend on the packager.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>For pgRouting they dont even bother to put a version<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><a href="https://www.ubuntuupdates.org/package/postgresql/xenial-pgdg/main/base/postgresql-13-pgrouting" target="_blank">https://www.ubuntuupdates.org/package/postgresql/xenial-pgdg/main/base/postgresql-13-pgrouting</a><o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>I recommend to do the following:<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Start doing the work from top-bottom:<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Postgres 14 + posgis 3.1, 3.2, 3.3, (no chance to use 2.5)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Then<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Postgres 13 + posgis 3.1, 3.2, 3.3, (no chance to use 2.5)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Then<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Postgres 12 + posgis 3.1, 3.2, 3.3, ...<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Evaluate the effort of doing those, As you already did an effort to with postgis 2.5 for postgres12<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Arial",sans-serif'>Then decide how to continue down to postgres10.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Arial",sans-serif'>Vicky<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Arial",sans-serif'><o:p> </o:p></span></p></div></div><p class=MsoNormal><br clear=all><br>-- <o:p></o:p></p><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><pre>Georepublic UG (haftungsbeschränkt)<o:p></o:p></pre><pre>Salzmannstraße 44, <o:p></o:p></pre><pre>81739 München, Germany<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Vicky Vergara<o:p></o:p></pre><pre>Operations Research<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a><o:p></o:p></pre><pre>Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a><o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Tel: +49 (089) 4161 7698-1<o:p></o:p></pre><pre>Fax: +49 (089) 4161 7698-9<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Commercial register: Amtsgericht München, HRB 181428<o:p></o:p></pre><pre>CEO: Daniel Kastl<o:p></o:p></pre><pre><o:p> </o:p></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></body></html>