<div dir="ltr"><div>I just had the time to try a postgis install but reached to a different result of missing libCGAL. <br></div><div>Here's my setting:</div><div><br></div><div>Yesterday upgraded to Focal</div><div><br></div><div>- Added apt repo for postgres.</div><div>- Installed postgres-12 and postgis<br></div><div>- Tried to do 'CREATE EXTENSION postgis':<br></div><div><span style="font-family:monospace">ERROR: could not load library "/usr/lib/postgresql/12/lib/postgis-3.so": libCGAL_Core.so.13: cannot open shared object file: No such file or directory</span></div><div><br></div><div>I tried to manually install libcgal but this doesn't appear to be available for focal yet.</div><div>See: <a href="https://packages.ubuntu.com/search?keywords=cgal">https://packages.ubuntu.com/search?keywords=cgal</a></div><div><br></div><div>The sfcgal library used by postgis is available though:</div><div><span style="font-family:monospace">% sudo dpkg --list |grep cgal<br>ii libcgal-dev:amd64 5.0.2-3 amd64 C++ library for computational geometry (development files)<br>ii libsfcgal1 1.3.7-4ubuntu3 amd64 Library for ISO 19107:2013 and OGC SFA 1.2 for 3D operations</span><br></div><div><br></div><div>Your email has a curious parallel to my installation attempt of qgis though which ended at:<br></div><div></div><div><span style="font-family:monospace">Setting up qgis-providers (1:3.12.2+32focal) ...<br>/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.26: undefined symbol:<br> GEOSMakeValid_r</span><br></div><div>Leaving me with an invalid setup of dpkg (only clears after uninstalling qgis-providers).<br></div><div><br></div><div>All in all, it seems the packages are in an incomplete state currently.</div><div><br></div><div>Tom<br></div><div><br></div><div><br></div><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></div>