Hi Tom,
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.
Marco
Op 14-5-2020 om 10:32 schreef Tom van Tilburg:
I think I solved it.
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).
This issue put me on the right track:
https://github.com/OSGeo/gdal/issues/2214
T.
On Wed, May 13, 2020 at 3:15 PM Marco Boeringa
<[email protected] <mailto:[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
<http://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] <mailto:[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] <mailto:[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]
<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected] <mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected] <mailto:[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
