<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Tom,</p>
<p>One more question:</p>
<p>After successfully installing the PostGIS 3.0.1 extension using
CREATE EXTENSION in pgAdmin4 on PostgreSQL 12.3 on Ubuntu 20.04
Focal, I now ran into an issue where it appears the 'ST_Accum'
function is missing in my PostGIS install. My code calls this, and
it failed. I then had a look at the function list in pgAdmin, and
indeed 'ST_Accum' is not listed. I do see loads of other PostGIS
functions, just 'ST_Accum' seems missing (although I cannot
garantuee there are a few more missing functions, but the list
seems pretty comprehensive from a quick look, and the CREATE
EXTENSION call went without a hitch).</p>
<p>Can you confirm you see 'ST_Accum' in your PostGIS 3.0.1 function
list if you look in pgAdmin? The PostGIS Help does not mention
some deprecation of this function:</p>
<p><a class="moz-txt-link-freetext" href="https://postgis.net/docs/ST_Accum.html">https://postgis.net/docs/ST_Accum.html</a></p>
<p>Marco<br>
</p>
<div class="moz-cite-prefix">Op 14-5-2020 om 11:42 schreef Tom van
Tilburg:<br>
</div>
<blockquote type="cite"
cite="mid:CAP3PPDhO29KNMTgZZyukw6icPgTd8TOKeZ6YYgEsO25b+R2CPQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Whatever lives in /usr/local/lib was my manual build so I
had to delete that manually.<br>
</div>
<div>I did `sudo rm /usr/local/lib/libgeos*` (same for proj and
sfcgal)</div>
<div>On top of that I purged all old package configurations
`sudo apt purge <packagename>` just to be sure but I
don't think it is needed.</div>
<div><br>
</div>
<div>Best,</div>
<div> Tom<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, May 14, 2020 at 10:45
AM Marco Boeringa <<a href="mailto:marco@boeringa.demon.nl"
moz-do-not-send="true">marco@boeringa.demon.nl</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Tom,</p>
<p>Thanks for the tip, but what did you do to remove the old
install? Did you rely on Apt or Synaptic to remove the old
libgeos version, or did you manually clean up folders? I
had two versions of libgeos as well (3.7 and 3.8) if I
remember well (need to start up the VM again to check),
and removed the older one through Synaptic just leaving
the 3.8 version, but that wasn't enough to solve my
particular issues.</p>
<p>Marco<br>
</p>
<div>Op 14-5-2020 om 10:32 schreef Tom van Tilburg:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>I think I solved it.</div>
<div>The issue lies with gdal, not postgis (test by
running `gdalinfo`), and it turns out there was an old
install of libgeos (3.7) in my /us/local/lib. After
simply removing all related files in /usr/local/lib
gdal (and postgis and qgis) stopped complaining (I had
to remove old installs of geos, proj and sfcgal for
that).<br>
</div>
<div><br>
</div>
<div>This issue put me on the right track:</div>
<div><a href="https://github.com/OSGeo/gdal/issues/2214"
target="_blank" moz-do-not-send="true">https://github.com/OSGeo/gdal/issues/2214</a></div>
<div><br>
</div>
<div>T.<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, May 13, 2020
at 3:15 PM Marco Boeringa <<a
href="mailto:marco@boeringa.demon.nl"
target="_blank" moz-do-not-send="true">marco@boeringa.demon.nl</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Thanks Tom,</p>
<p>I have seen a similar error related to the
"libgdal26" library, but that was after other
trials to get something running on Ubuntu 20.04
Focal, where I successfully installed PostGIS
2.5.4, but then encountered issues when my code
called the "postgis_full_version()" function and
errored out with the error message below related
to the "libgdal.so.26" library. However, as said,
this was with PostGIS 2.5.4, not with the PostGIS
3.0.1 I actually want to install at this moment
and that gave the other error related to the
"postgis-3.so" library.<br>
</p>
<p>SQL Error [XX000]: ERROR: could not load library
"/usr/lib/postgresql/11/lib/<a
href="http://rtpostgis-2.5.so" target="_blank"
moz-do-not-send="true">rtpostgis-2.5.so</a>":
/usr/lib/libgdal.so.26: undefined symbol:
GEOSMakeValid_r<br>
Where: SQL statement "SELECT
public.postgis_gdal_version()"<br>
PL/pgSQL function postgis_full_version() line 34
at SQL statement</p>
<p>Marco<br>
</p>
<div><br>
<br>
<div dir="auto">
<div>Sorry for the short answer, am on the way
currently. Will try to do a decent report
tonight.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Error is roughly the same but
comes from libgdal26 in my case when doing apt
install qgis after an upgrade to 20.04.</div>
<div dir="auto"><br>
</div>
<div dir="auto">best, Tom<br>
<br>
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">On Wed, 13
May 2020, 14:48 Marco Boeringa, <<a
href="mailto:marco@boeringa.demon.nl"
target="_blank" moz-do-not-send="true">marco@boeringa.demon.nl</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Thanks for the response Tom, but
could you be a bit more specific? <br>
</p>
<p>What do you mean with "Same problem
with qgis"? Do you mean you've also
encountered a "undefined symbol:
GEOSMakeValid" error related to the
"postgis-3.so" library when trying to
use some tool in QGIS?</p>
<p>I have installed PostgreSQL 12 and
PostGIS 3.0.1 via Synaptic on Ubuntu
20.04 (Focal) and use CREATE EXTENSION
(via pgAdmin4), when I encounter the
error.<br>
</p>
<div>Marco</div>
<div><br>
</div>
<div>Op 13-5-2020 om 14:40 schreef Tom
van Tilburg:<br>
</div>
<blockquote type="cite">
<div dir="auto">Same problem with qgis</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On
Wed, 13 May 2020, 11:14 Marco
Boeringa, <<a
href="mailto:marco@boeringa.demon.nl"
rel="noreferrer" target="_blank"
moz-do-not-send="true">marco@boeringa.demon.nl</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hi
all,<br>
<br>
Is there someone who can confirm
they have been able to install
PostGIS <br>
3.0.1 via the official APT
repository?:<br>
<br>
<a
href="https://wiki.postgresql.org/wiki/Apt"
rel="noreferrer noreferrer
noreferrer" target="_blank"
moz-do-not-send="true">https://wiki.postgresql.org/wiki/Apt</a><br>
<br>
After using the Synaptics Package
Manager to install the three
packages <br>
involved <br>
("postgresql-12-postgis-3"/"postgresql-12-postgis-3-dbgsym"/"postgresql-12-postgis-3-scripts"),
<br>
and subsequently trying to create
the PostGIS extension in pgAdmin4,
I <br>
get the following error:<br>
<br>
ERROR: could not load library
"/usr/lib/postgresql/12/lib/postgis-3.so":
<br>
/usr/lib/postgresql/12/lib/postgis-3.so: undefined symbol: GEOSMakeValid<br>
<br>
I have been trying different
things to fix this for past two
days <br>
including re-install, but to no
avail. I have also attempted to
include <br>
the UbuntuGIS repository as a
potential alternative resource of
PostGIS <br>
packages, but discovered the
UbuntuGIS repository is lagging
behind and <br>
doesn't yet have packages for
20.04LTS.<br>
<br>
Marco<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a
href="mailto:postgis-users@lists.osgeo.org"
rel="noreferrer noreferrer"
target="_blank"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer noreferrer
noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer" target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></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>