<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi all,</p>
<p>Anyone an idea what is wrong? <br>
</p>
<p>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. <br>
</p>
<p>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.</p>
<p>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: </p>
<p><a class="moz-txt-link-freetext"
href="https://wiki.postgresql.org/wiki/Apt">https://wiki.postgresql.org/wiki/Apt</a><br>
</p>
<div class="moz-forward-container">This is the proper way to do
this, isn't it? Or is there some other repository I need to
access?</div>
<div class="moz-forward-container"><br>
</div>
<div class="moz-forward-container">Marco Boeringa<br>
</div>
<div class="moz-forward-container"><br>
</div>
ERROR:<br>
<p>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</p>
<p>ERROR DETAILS in Synaptic:<br>
</p>
<p>Preparing to unpack
.../postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb
...<br>
Unpacking postgresql-11-postgis-3-scripts
(3.0.1+dfsg-2.pgdg20.04+1) ...<br>
dpkg: error processing archive
/var/cache/apt/archives/postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb
(--unpack):<br>
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<br>
dpkg-deb: error: paste subprocess was killed by signal (Broken
pipe)<br>
Errors were encountered while processing:<br>
/var/cache/apt/archives/postgresql-11-postgis-3-scripts_3.0.1+dfsg-2.pgdg20.04+1_all.deb<br>
E: Sub-process /usr/bin/dpkg returned an error code (1)<br>
A package failed to install. Trying to recover:<br>
dpkg: dependency problems prevent configuration of
postgresql-11-postgis-3:<br>
postgresql-11-postgis-3 depends on
postgresql-11-postgis-3-scripts; however:<br>
Package postgresql-11-postgis-3-scripts is not installed.<br>
<br>
dpkg: error processing package postgresql-11-postgis-3
(--configure):<br>
dependency problems - leaving unconfigured<br>
Processing triggers for postgresql-common (214) ...<br>
Building PostgreSQL dictionaries from installed myspell/hunspell
packages...<br>
en_us<br>
Removing obsolete dictionary files:<br>
Errors were encountered while processing:<br>
postgresql-11-postgis-3<br>
<br>
</p>
<br>
<div class="moz-forward-container"> <br>
-------- Doorgestuurd bericht --------
<table class="moz-email-headers-table" cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<th valign="BASELINE" nowrap="nowrap" align="RIGHT">Onderwerp:
</th>
<td>Problem with "undefined symbol: GEOSMakeValid_r"</td>
</tr>
<tr>
<th valign="BASELINE" nowrap="nowrap" align="RIGHT">Datum: </th>
<td>Wed, 6 May 2020 16:56:49 +0200</td>
</tr>
<tr>
<th valign="BASELINE" nowrap="nowrap" align="RIGHT">Van: </th>
<td>Marco Boeringa <a class="moz-txt-link-rfc2396E"
href="mailto:marco@boeringa.demon.nl"><marco@boeringa.demon.nl></a></td>
</tr>
<tr>
<th valign="BASELINE" nowrap="nowrap" align="RIGHT">Aan: </th>
<td><a class="moz-txt-link-abbreviated"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a></td>
</tr>
</tbody>
</table>
<br>
<br>
Hi all,<br>
<br>
I hope someone has a recommendation for how to solve this:<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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")<br>
<br>
Marco<br>
<br>
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<br>
Where: SQL statement "SELECT public.postgis_gdal_version()"<br>
PL/pgSQL function postgis_full_version() line 34 at SQL statement<br>
<br>
</div>
</body>
</html>