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

[Tom van Tilburg]

Whatever lives in /usr/local/lib was my manual build so I had to delete
that manually.
I did  `sudo rm /usr/local/lib/libgeos*` (same for proj and sfcgal)
On top of that I purged all old package configurations `sudo apt purge
<packagename>` just to be sure but I don't think it is needed.

Best,
 Tom

On Thu, May 14, 2020 at 10:45 AM Marco Boeringa <marco at boeringa.demon.nl>
wrote:

> 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 <marco at boeringa.demon.nl>
> 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, <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>
>>> 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
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users
>>>
>>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> 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/20200514/90b90101/attachment.html>