[postgis-users] postgis.sql

[Mark Vantzelfde]

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 <
mark.cave-ayland at siriusit.co.uk> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Mark Vantzelfde
NetMasters, Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090910/d2871df1/attachment.html>