[postgis-users] postgis.sql

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Thu Sep 10 02:34:48 PDT 2009

Mark Vantzelfde wrote:

> psql:postgis.sql:53: NOTICE:  type "spheroid" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:postgis.sql:53: ERROR:  could not load library 
> "/opt/PostgreSQL/8.4/lib/postgresql/postgis-1.4.so 
> <http://postgis-1.4.so>": libgeos_c.so.1: cannot open shared object 
> file: No such file or directory
> psql:postgis.sql:59: ERROR:  current transaction is aborted, commands 
> ignored until end of transaction block
> ...

Remember that the various .so libraries need to be visible to the server 
at runtime, not just at build time. So you can either tweak your 
PostgreSQL startup script to include a LD_LIBRARY_PATH=/usr/local/lib 
declaration (assuming you used the defaults when you built GEOS/PROJ.4), 
or tweak /etc/ld.so.conf with the relevant locations and then re-run 



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list