[postgis-users] postgis.sql

[Mark Cave-Ayland]

Mark Vantzelfde wrote:

> Mark, not sure what you mean by "tweak your PostgreSQL startup script". 
> Happy to try that if I did.
> 
> I copied the postgis-1.4.so <http://postgis-1.4.so> lib from my PostGIS 
> build area to /opt/PostgreSQL/8.4/lib/postgresql. No help
> 
> I checked and the geos/proj.4 libs appear to be in /usr/local/lib.
> 
> I set 
> LD_LIBRARY_PATH=/usr/PostGIS/postgis-1.4.0/postgis:/usr/local/lib:/usr/lib
> No help

The reason you need to tweak the statup script is because if you start 
PostgreSQL using "service postgresql start" or "/etc/init.d/postgresql 
start" then the script will switch to the postgres user in order to 
launch the server.

Hence even if you set your LD_LIBRARY_PATH as above and restart 
PostgreSQL, this will only affect the current user and will not be 
propagated to the postgres user. So you'll need to alter your startup 
script to ensure that LD_LIBRARY_PATH is being set correctly for the 
postgres user when PostgreSQL is launched.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

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