[postgis-users] PostGIS non functional on Ubuntu 14.04

Rémi Cura remi.cura at gmail.com
Tue Jul 29 01:22:01 PDT 2014 

Hey,
glad it finally worked !

On a side note,
if you want you don't need to log as postgres to restart the server,
you can just do something like
`sudo pg_ctlcluster 9.3 main restart`
Cheers,
Rémi-C


2014-07-29 9:44 GMT+02:00 Luís de Sousa <luis.a.de.sousa at gmail.com>:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140729/f84834a4/attachment.html>

More information about the postgis-users mailing list