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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to