Postgresql 10 Error -postgis extension error: usr/lib/liblwgeom-2.4.so.0: undefined symbol: GEOSClipByRect

[Ankush]

Hi all,
Iḿ receiving an error after creating the database and database user. 

ERROR:  could not load library "/usr/lib/postgresql/10/lib/postgis-2.4.so": /usr/lib/liblwgeom-2.4.so.0: undefined symbol: GEOSClipByRect. I also cannot locate liblwgeom-2.4.so.0 in the folder. 

I am trying to install the Postgis on my ubuntu system for django framework. But everytime when i run the command ./configure it gives me error

I will highly appreciate any pointers to rectify this error.  

Thanks in advance
Ankush Sharma

[Tom Kazimiers]

Hi Ankush,

On Fri, Apr 06, 2018 at 02:44:14AM -0700, Ankush wrote:
>Iḿ receiving an error after creating the database and database user.
>
>ERROR: could not load library "/usr/lib/postgresql/10/lib/postgis-2.4.so":
>/usr/lib/liblwgeom-2.4.so.0: undefined symbol: GEOSClipByRect. I also
>cannot locate liblwgeom-2.4.so.0 in the folder.

That's an error I haven't seen before, therefore I am only guessing.
Given that the next CATMAID release will be the first one that requires
Postgres 10, our "stable" branch of our documentation on catmaid.org
might not reflect all needed dependencies. Already change in the
"latest" branch and listed in the UPDATE.md file, make sure you have
these OS packages installed: binutils, libproj-dev and gdal-bin, i.e. on
Ubuntu:

sudo apt-get install binutils libproj-dev gdal-bin

Do you have those packages installed and still see this error?

If you still see it, I'd be interested to see the output of

ldd /usr/lib/postgresql/10/lib/postgis-2.4.so

and

ld -v /usr/lib/postgresql/10/lib/postgis-2.4.so

This might help to find other unmet dependencies of PostGIS. I take it
you are installing Postgres and Postgis from the Postgres APT repo (as
descriped in the introduction of the installation instructions [1].

Cheers,
Tom

[1] http://catmaid.readthedocs.io/en/latest/installation.html

>I am trying to install the Postgis on my ubuntu system for django
>framework. But everytime when i run the command ./configure it gives me
>error
>
>I will highly appreciate any pointers to rectify this error.
>
>
>Thanks in advance
>Ankush Sharma
>

>--
>You received this message because you are subscribed to the Google Groups "CATMAID" group.
>To unsubscribe from this group and stop receiving emails from it, send an email to catmaid+u...@googlegroups.com.

>For more options, visit https://groups.google.com/d/optout.

[Ankush]

Hi Tom,

Multiple versions of postgresql and postgis extension were creating troubles in loading library. Reinstalling dependencies (such as geos and Gdal) and Postgis extension solved the problem!