I just had the time to try a postgis install but reached to a different result of missing libCGAL. Here's my setting:
Yesterday upgraded to Focal - Added apt repo for postgres. - Installed postgres-12 and postgis - Tried to do 'CREATE EXTENSION postgis': 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 I tried to manually install libcgal but this doesn't appear to be available for focal yet. See: https://packages.ubuntu.com/search?keywords=cgal The sfcgal library used by postgis is available though: % sudo dpkg --list |grep cgal ii libcgal-dev:amd64 5.0.2-3 amd64 C++ library for computational geometry (development files) ii libsfcgal1 1.3.7-4ubuntu3 amd64 Library for ISO 19107:2013 and OGC SFA 1.2 for 3D operations Your email has a curious parallel to my installation attempt of qgis though which ended at: Setting up qgis-providers (1:3.12.2+32focal) ... /usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r Leaving me with an invalid setup of dpkg (only clears after uninstalling qgis-providers). All in all, it seems the packages are in an incomplete state currently. Tom On Wed, May 13, 2020 at 3:15 PM Marco Boeringa <[email protected]> wrote: > Thanks Tom, > > 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. > > SQL Error [XX000]: ERROR: could not load library > "/usr/lib/postgresql/11/lib/rtpostgis-2.5.so": /usr/lib/libgdal.so.26: > undefined symbol: GEOSMakeValid_r > Where: SQL statement "SELECT public.postgis_gdal_version()" > PL/pgSQL function postgis_full_version() line 34 at SQL statement > > Marco > > > Sorry for the short answer, am on the way currently. Will try to do a > decent report tonight. > > Error is roughly the same but comes from libgdal26 in my case when doing > apt install qgis after an upgrade to 20.04. > > best, Tom > > On Wed, 13 May 2020, 14:48 Marco Boeringa, <[email protected]> > wrote: > >> Thanks for the response Tom, but could you be a bit more specific? >> >> 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? >> >> 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. >> Marco >> >> Op 13-5-2020 om 14:40 schreef Tom van Tilburg: >> >> Same problem with qgis >> >> On Wed, 13 May 2020, 11:14 Marco Boeringa, <[email protected]> >> wrote: >> >>> Hi all, >>> >>> Is there someone who can confirm they have been able to install PostGIS >>> 3.0.1 via the official APT repository?: >>> >>> https://wiki.postgresql.org/wiki/Apt >>> >>> After using the Synaptics Package Manager to install the three packages >>> involved >>> ("postgresql-12-postgis-3"/"postgresql-12-postgis-3-dbgsym"/"postgresql-12-postgis-3-scripts"), >>> >>> and subsequently trying to create the PostGIS extension in pgAdmin4, I >>> get the following error: >>> >>> ERROR: could not load library "/usr/lib/postgresql/12/lib/postgis-3.so": >>> /usr/lib/postgresql/12/lib/postgis-3.so: undefined symbol: GEOSMakeValid >>> >>> I have been trying different things to fix this for past two days >>> including re-install, but to no avail. I have also attempted to include >>> the UbuntuGIS repository as a potential alternative resource of PostGIS >>> packages, but discovered the UbuntuGIS repository is lagging behind and >>> doesn't yet have packages for 20.04LTS. >>> >>> Marco >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing >> [email protected]https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
