<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">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">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">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">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">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">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">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer noreferrer" target="_blank">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">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">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">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>