<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Regina,</p>
<p>thanks to your information I could find a workaround. I ended up
removing the postgresql and ubuntugis-unstable repositories along
with the installed software and installed docker to use the
alpine-based docker files
(<a class="moz-txt-link-freetext" href="https://registry.hub.docker.com/r/postgis/postgis/">https://registry.hub.docker.com/r/postgis/postgis/</a>). The restore
was successful and everything seems to be working so far.</p>
<p>Thanks for the help!<br>
</p>
<div class="moz-cite-prefix">Am 20.12.2022 um 18:02 schrieb Regina
Obe:<br>
</div>
<blockquote type="cite"
cite="mid:002901d91494$c8c7c170$5a574450$@pcorp.us">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}@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;}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;}p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}ol
{margin-bottom:0in;}ul
{margin-bottom:0in;}</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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">If
you have </span>ubuntugis-unstable<span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
installed too, it’s quite possible that your GEOS is coming
from ubuntugis unstable<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">and
your postgis is coming from apt.postgresql.org. Even worse
as I recall, I think ubuntugis relegates compiling of
postgis upstream (main repo), so you might still end up with
a PostGIS compiled with a lower version.<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">apt.postgresql.org
builds against whatever the base repo is of Ubuntu/Debian
etc. Last I checked, all stable releases (at least for
Ubuntu) I could get put you at GEOS 3.10. So I suspect your
Mint postgis was at best compiled with GEOS 3.10.<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">Unfortunately
the GEOS is checked at compile time for enabling features,
not runtime, but our full version exposes<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">the
runtime that is being used, which for most cases is useful,
except for the case where new features are disabled.<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">Sandro
and Paul, is there any way we can expose the compiled
version of GEOS and Proj? <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This
isn’t the first time someone has been confused by this issue
and it’s been even worse with Proj (around those times when
the proj.db changed)<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
think I asked before but I forget what you two answered.<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">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regina<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 class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On
Behalf Of </b>Karsten Tebling<br>
<b>Sent:</b> Tuesday, December 20, 2022 6:07 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> [postgis-users] error: Directed line
merging requires GEOS-3.11 or higher<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Hello,<o:p></o:p></p>
<p>I'm trying to restore a backup from a windows installation
to a new linux mint 21 installation but it always fails with
"error: Directed line merging requires GEOS-3.11 or higher".
According to the postgis_full_version both installations
should support geos 3.11, but I do get the error anyway. I'm
using pgadmin4-desktop (installed via apt <a
href="https://www.pgadmin.org/download/pgadmin-4-apt/"
moz-do-not-send="true" class="moz-txt-link-freetext">https://www.pgadmin.org/download/pgadmin-4-apt/</a>)
to execute the queries.<o:p></o:p></p>
<p>postgis_full_version:<o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0
level1 lfo1">windows: POSTGIS="3.3.2 3.3.2" [EXTENSION]
PGSQL="140" GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1"
LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1"
WAGYU="0.5.0 (Internal)"<o:p></o:p></li>
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0
level1 lfo1">linux mint: POSTGIS="3.3.2 4975da8"
[EXTENSION] PGSQL="150" GEOS="3.11.1-CAPI-1.17.1"
PROJ="8.2.1" LIBXML="2.9.13" LIBJSON="0.15"
LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"<o:p></o:p></li>
</ul>
<p>The linux mint is a fresh installation, I installed
postgresql and postgis via PostgreSQL Apt Repository (<a
href="https://www.postgresql.org/download/linux/ubuntu/"
moz-do-not-send="true" class="moz-txt-link-freetext">https://www.postgresql.org/download/linux/ubuntu/</a>),
using the command:<o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1
level1 lfo2">sudo apt install postgresql-15 postgis
postgresql-15-postgis-3<o:p></o:p></li>
</ul>
<p>Another ppa I have in use is ubuntugis-unstable, it also
includes postgis - could this be a reason for the problem?<o:p></o:p></p>
<p>Help would be greatly appreciated.<o:p></o:p></p>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>