[postgis-users] Fwd: Problem with "undefined symbol: GEOSMakeValid_r"

[Marco Boeringa]

Hi all,

Anyone an idea what is wrong?

I am still running into the issues described below trying to upgrade my 
PostGIS install from 2.5.4 to 3.0.1, and am starting to get convinced 
something in the PostGIS installers for Ubuntu 20.04 Focal is busted.

Why would the PostGIS 3.0.1 installation fail on the inability to 
overwrite the "shp2pgsql-gui.desktop" file? And if that is not allowed 
to be overwritten, why aren't there PostGIS version specific versions 
and folders for this file? Note that this error message seems related to 
the "scripts" package, see error messages below.

Note that I used the 'apt' repository key as officially listed here to 
get access to the installations from apt and the Synaptic Package Manager:

https://wiki.postgresql.org/wiki/Apt

This is the proper way to do this, isn't it? Or is there some other 
repository I need to access?

Marco Boeringa

ERROR:

E: 
/var/cache/apt/archives/postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb: 
trying to overwrite 
'/usr/share/postgresql/11/applications/shp2pgsql-gui.desktop', which is 
also in package postgresql-11-postgis-2.5-scripts 2.5.4+dfsg-1.pgdg20.04+1

ERROR DETAILS in Synaptic:

Preparing to unpack 
.../postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb ...
Unpacking postgresql-11-postgis-3-scripts (3.0.1+dfsg-2.pgdg20.04+1) ...
dpkg: error processing archive 
/var/cache/apt/archives/postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb 
(--unpack):
  trying to overwrite 
'/usr/share/postgresql/11/applications/shp2pgsql-gui.desktop', which is 
also in package postgresql-11-postgis-2.5-scripts 2.5.4+dfsg-1.pgdg20.04+1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Errors were encountered while processing:
  /var/cache/apt/archives/postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
dpkg: dependency problems prevent configuration of postgresql-11-postgis-3:
  postgresql-11-postgis-3 depends on postgresql-11-postgis-3-scripts; 
however:
   Package postgresql-11-postgis-3-scripts is not installed.

dpkg: error processing package postgresql-11-postgis-3 (--configure):
  dependency problems - leaving unconfigured
Processing triggers for postgresql-common (214) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
   en_us
Removing obsolete dictionary files:
Errors were encountered while processing:
  postgresql-11-postgis-3



-------- Doorgestuurd bericht --------
Onderwerp: 	Problem with "undefined symbol: GEOSMakeValid_r"
Datum: 	Wed, 6 May 2020 16:56:49 +0200
Van: 	Marco Boeringa <marco at boeringa.demon.nl>
Aan: 	postgis-users at lists.osgeo.org



Hi all,

I hope someone has a recommendation for how to solve this:

When I attempted to upgrade my 19.10 Ubuntu installation to 20.04, I 
first ran into an issue that I couldn't run the Ubuntu upgrade 
installer, unless I uninstalled PostGIS 2.5 first. It complained about 
PostGIS being on the "black list for removal" or something similar. So, 
I finally decided to uninstall the PostGIS 2.5 through the Synaptics 
Package manager of Ubuntu, after which I was able to upgrade to 20.04 Focal.

I then attempted to re-install PostGIS 2.5 from the Synaptic Pacakage 
manager again. After several attempts, I now have it installed, and I 
can access spatial data from the existing PostgreSQL 11 database using 
e.g. DBeaver.

However, as part of my code, I had a call to the 
"PostGIS_Full_Version()" function, and that now fails with the error 
attached below. Is this still an indication the PostGIS 2.5 install is 
somehow broken? I have already tried to re-install "libgdal26", as is 
referenced in the error message, but to no avail.

I have also attempted to install the "postgresql-11-postgis-3" and 
"postgresql-11-postgis-3-scripts" packages, in the hope of being able to 
solve the issue by upgrading PostGIS, but that failed as well, with 
Synaptic showing an error message and complaining about a shared library 
/ application that is also in the PostGIS 2.5 install and that "could 
not be overwritten" (file 
"usr/share/postgresql/11/applications/shp2pgsql-gui.desktop")

Marco

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200511/98e38425/attachment.html>