[postgis-users] Fwd: Re: Broken installs for PostGIS for Ubuntu 20.04LTS / Focal?

[Marco Boeringa]

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, <marco at boeringa.demon.nl 
<mailto:marco at boeringa.demon.nl>> 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,
>     <marco at boeringa.demon.nl <mailto:marco at boeringa.demon.nl>> 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
>         postgis-users at lists.osgeo.org
>         <mailto:postgis-users at lists.osgeo.org>
>         https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at lists.osgeo.org  <mailto:postgis-users at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/postgis-users

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