<div dir="ltr"><div><div><div><div><div>Hey,<br></div>glad it finally worked !<br><br></div>On a side note, <br></div>if you want you don't need to log as postgres to restart the server,<br></div>you can just do something like <br>
`sudo pg_ctlcluster 9.3 main restart`<br></div>Cheers,<br>Rémi-C<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-07-29 9:44 GMT+02:00 Luís de Sousa <span dir="ltr"><<a href="mailto:luis.a.de.sousa@gmail.com" target="_blank">luis.a.de.sousa@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello everyone, here is then the fix to this problem:<br>
<br>
$ sudo rm /usr/local/lib/libgeos_c.so*<br>
$ sudo rm /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so*<br>
$ sudo ldconfig<br>
$ sudo su postgres<br>
$ /etc/init.d/postgresql restart<br>
<div class="">$ psql pg_testing -c "create extension postgis"<br>
</div>CREATE EXTENSION<br>
<br>
Thank you all for replies that lead here. Best,<br>
<br>
Luís<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On 28 July 2014 17:42, Rémi Cura <<a href="mailto:remi.cura@gmail.com">remi.cura@gmail.com</a>> wrote:<br>
> Hmm, no luck :-(<br>
> If you don't want to take any chance,<br>
> don't delete the .so, but rename them (like libgeos_c.so.backup).<br>
> After any change on your lib, you should ldconfig anyway.<br>
><br>
> Cheers,<br>
> Rémi-C<br>
><br>
><br>
><br>
> 2014-07-28 17:26 GMT+02:00 António M. Rodrigues <<a href="mailto:amcrgrodrigues@gmail.com">amcrgrodrigues@gmail.com</a>>:<br>
><br>
>> Hi,<br>
>><br>
>> A while back I had a similar problem upgrading from 2.0 to 2.1<br>
>><br>
>> Going throught my notes I found this which might help:<br>
>><br>
>> ---<br>
>> sudo ln -s /usr/lib/postgresql/9.1/lib/<a href="http://postgis-2.1.so" target="_blank">postgis-2.1.so</a><br>
>> /usr/lib/postgresql/9.1/lib/postgis-2.0<br>
>> ldconfig<br>
>> ---<br>
>><br>
>> You're basically creating a symbolic link with the older library.<br>
>><br>
>> Hope it helps,<br>
>> António<br>
>><br>
>><br>
>> 2014-07-28 16:10 GMT+01:00 Luís de Sousa <<a href="mailto:luis.a.de.sousa@gmail.com">luis.a.de.sousa@gmail.com</a>>:<br>
>><br>
>>> Hi Mike, thank you for tips.<br>
>>><br>
>>> In fact I have several "old" .so files installed:<br>
>>><br>
>>> $ locate libgeos_c.so<br>
>>> /usr/lib/libgeos_c.so<br>
>>> /usr/lib/libgeos_c.so.1<br>
>>> /usr/lib/libgeos_c.so.1.8.2<br>
>>> /usr/local/lib/libgeos_c.so<br>
>>> /usr/local/lib/libgeos_c.so.1<br>
>>> /usr/local/lib/libgeos_c.so.1.7.1<br>
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so<br>
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1<br>
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1.7.1<br>
>>> /usr/local/src/geos-3.3.1/capi/.libs/libgeos_c.so.1.7.1T<br>
>>><br>
>>> /usr/share/gvSIG-desktop-2.0.0/gvSIG/extensiones/org.gvsig.raster.tilecache.app/install/files/native/libgeos_c.so.1<br>
>>> /usr/share/gvSIG-desktop-2.0.0/native/libgeos_c.so.1<br>
>>><br>
>>> The problem is that running dpkg only libgeos-3.4.2 shows up:<br>
>>><br>
>>> $ dpkg -l | grep libgeos<br>
>>> ii libgeos-3.4.2<br>
>>> 3.4.2-4ubuntu1 amd64<br>
>>> Geometry engine for Geographic Information Systems - C++ Library<br>
>>> ii libgeos-c1<br>
>>> 3.4.2-4ubuntu1 amd64<br>
>>> Geometry engine for Geographic Information Systems - C Library<br>
>>> ii libgeos-dev<br>
>>> 3.4.2-4ubuntu1 amd64<br>
>>> Geometry engine for GIS - Development files<br>
>>><br>
>>> Meaning that these old .so must be removed manually. In my experience<br>
>>> this always leads to other problems down the road. Any hints on how to<br>
>>> safely remove these old files is welcome.<br>
>>><br>
>>> Another thing: why were these files left in the system, if the<br>
>>> corresponding package is no longer installed? Is this a problem with<br>
>>> the Ubuntu upgrade procedure? Or an issue with the package itself?<br>
>>><br>
>>> Thank you,<br>
>>><br>
>>> Luís<br>
>>><br>
>>> On 28 July 2014 13:19, Mike Toews <<a href="mailto:mwtoews@gmail.com">mwtoews@gmail.com</a>> wrote:<br>
>>> > On 25 July 2014 20:03, Luís de Sousa <<a href="mailto:luis.a.de.sousa@gmail.com">luis.a.de.sousa@gmail.com</a>> wrote:<br>
>>> >> <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1310src" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1310src</a><br>
>>> ><br>
>>> > Whoa, someone edited those for "trusty", and are a bit off. I've<br>
>>> > rolled those back to 13.10, and assembled a virtual machine for more<br>
>>> > instructions. Look for more appropriate source build instructions at:<br>
>>> > <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404src" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404src</a><br>
>>> ><br>
>>> > And really simple package installation instructions at:<br>
>>> > <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404pkg" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1404pkg</a><br>
>>> ><br>
>>> > While I'm unable to reproduce your error from Ubuntu packages, it<br>
>>> > looks like you are on the correct track on removing older libraries of<br>
>>> > lwgeom and geos_c. E.g., a clean install from packages should see<br>
>>> > this:<br>
>>> ><br>
>>> > $ locate libgeos_c.so<br>
>>> > /usr/lib/libgeos_c.so.1<br>
>>> > /usr/lib/libgeos_c.so.1.8.2<br>
>>> ><br>
>>> > -Mike<br>
>>> > _______________________________________________<br>
>>> > postgis-users mailing list<br>
>>> > <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>> > <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>>> _______________________________________________<br>
>>> postgis-users mailing list<br>
>>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></div></div></blockquote></div><br></div>