From: | Mark Wynter <mark(at)dimensionaledge(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem setting environmental variables for postgresql or plpythonu |
Date: | 2012-07-20 00:57:26 |
Message-ID: | A02063CD-841A-4CD4-8C9D-2C3DF0ED2CE6@dimensionaledge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I''m hoping someone can help me out. I'm wanting to run GRASS GIS from within a plpythonu function block. But to run GRASS GIS externally, the following environmental variables need to be available to the Postgresql server...
GISBASE='/usr/local/grass-6.4.3svn'
PATH='$PATH:$GISBASE/bin:$GISBASE/scripts:$GISBASE/lib'
PYTHONPATH='${PYTHONPATH}:$GISBASE/etc/python/'
PYTHONPATH='${PYTHONPATH}:$GISBASE/etc/python/grass'
PYTHONPATH='${PYTHONPATH}:$GISBASE/etc/python/grass/script'
LD_LIBRARY_PATH='$LD_LIBRARY_PATH:$GISBASE/lib'
GIS_LOCK='$$'
GISRC='$HOME/.grassrc6'
Reference: http://grass.osgeo.org/wiki/GRASS_and_Python
So far I've added these variables to /etc/bash.bashrc
which makes them available to the postgres user (but not the server or pl/python).
And I've had no success adding them to...
/etc/postgresql/9.1/main/environment
#Shell commands are not evaluated.
Any suggestions would be appreciated...
Thanks
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Martin French | 2012-07-20 06:59:02 | Re: How to stop a query |
Previous Message | Nick | 2012-07-19 21:11:07 | Re: High CPU on read-only streaming replication server |