[postgis-users] PostGIS non functional on Ubuntu 14.04

[Luís de Sousa]

Hello everyone, here is then the fix to this problem:

$ sudo rm /usr/local/lib/libgeos_c.so*
$ sudo rm /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so*
$ sudo ldconfig
$ sudo su postgres
$ /etc/init.d/postgresql restart
$ psql pg_testing -c "create extension postgis"
CREATE EXTENSION

Thank you all for replies that lead here. Best,

Luís


On 28 July 2014 17:42, Rémi Cura <remi.cura at gmail.com> wrote:
> Hmm, no luck :-(
> If you don't want to take any chance,
> don't delete the .so, but rename them (like libgeos_c.so.backup).
> After any change on your lib, you should ldconfig anyway.
>
> Cheers,
> Rémi-C
>
>
>
> 2014-07-28 17:26 GMT+02:00 António M. Rodrigues <amcrgrodrigues at gmail.com>:
>
>> Hi,
>>
>> A while back I had a similar problem upgrading from 2.0 to 2.1
>>
>> Going throught my notes I found this which might help:
>>
>> ---
>> sudo ln -s /usr/lib/postgresql/9.1/lib/postgis-2.1.so
>> /usr/lib/postgresql/9.1/lib/postgis-2.0
>> ldconfig
>> ---
>>
>> You're basically creating a symbolic link with the older library.
>>
>> Hope it helps,
>> António
>>
>>
>> 2014-07-28 16:10 GMT+01:00 Luís de Sousa <luis.a.de.sousa at gmail.com>:
>>
>>> Hi Mike, thank you for tips.
>>>
>>> In fact I have several "old" .so files installed:
>>>
>>> $ locate libgeos_c.so
>>> /usr/lib/libgeos_c.so
>>> /usr/lib/libgeos_c.so.1
>>> /usr/lib/libgeos_c.so.1.8.2
>>> /usr/local/lib/libgeos_c.so
>>> /usr/local/lib/libgeos_c.so.1
>>> /usr/local/lib/libgeos_c.so.1.7.1
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1.7.1
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1.7.1T
>>>
>>> /usr/share/gvSIG-desktop-2.0.0/gvSIG/extensiones/org.gvsig.raster.tilecache.app/install/files/native/libgeos_c.so.1
>>> /usr/share/gvSIG-desktop-2.0.0/native/libgeos_c.so.1
>>>
>>> The problem is that running dpkg only libgeos-3.4.2 shows up:
>>>
>>> $ dpkg -l | grep libgeos
>>> ii  libgeos-3.4.2
>>> 3.4.2-4ubuntu1                                      amd64
>>> Geometry engine for Geographic Information Systems - C++ Library
>>> ii  libgeos-c1
>>> 3.4.2-4ubuntu1                                      amd64
>>> Geometry engine for Geographic Information Systems - C Library
>>> ii  libgeos-dev
>>> 3.4.2-4ubuntu1                                      amd64
>>> Geometry engine for GIS - Development files
>>>
>>> Meaning that these old .so must be removed manually. In my experience
>>> this always leads to other problems down the road. Any hints on how to
>>> safely remove these old files is welcome.
>>>
>>> Another thing: why were these files left in the system, if the
>>> corresponding package is no longer installed? Is this a problem with
>>> the Ubuntu upgrade procedure? Or an issue with the package itself?
>>>
>>> Thank you,
>>>
>>> Luís
>>>
>>> On 28 July 2014 13:19, Mike Toews <mwtoews at gmail.com> wrote:
>>> > On 25 July 2014 20:03, Luís de Sousa <luis.a.de.sousa at gmail.com> wrote:
>>> >> http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1310src
>>> >
>>> > Whoa, someone edited those for "trusty", and are a bit off. I've
>>> > rolled those back to 13.10, and assembled a virtual machine for more
>>> > instructions. Look for more appropriate source build instructions at:
>>> > http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404src
>>> >
>>> > And really simple package installation instructions at:
>>> > http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404pkg
>>> >
>>> > While I'm unable to reproduce your error from Ubuntu packages, it
>>> > looks like you are on the correct track on removing older libraries of
>>> > lwgeom and geos_c. E.g., a clean install from packages should see
>>> > this:
>>> >
>>> > $ locate libgeos_c.so
>>> > /usr/lib/libgeos_c.so.1
>>> > /usr/lib/libgeos_c.so.1.8.2
>>> >
>>> > -Mike
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at lists.osgeo.org
>>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users