I did the following: - changed the LD_LIBRARY_PATH setting in the start() function of the postgresql-8.4 script in /etc/init.d to include /usr/lib:/usr/local/lib. - stopped and started postgresql-8.4. - ran the postgis.sql file and it ran successfully - ran the spatial_ref_sys.sql and it ran successfully
Thanks, everyone! Mark On Thu, Sep 10, 2009 at 6:24 AM, Mark Cave-Ayland < [email protected]> wrote: > 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 > -- Mark Vantzelfde NetMasters, Inc.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
