Problem setting environmental variables for postgresql or plpythonu
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
Mark Wynter wrote:
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...
[...]
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...
What if you set the environment variables in the Python function?
I don't speak Python, but I guess you can set environment
variables in this language.
Other than that, it would be interesting to know which
operating system you are using and how you start the server.
On Linux for example, it works quite fine to export a
variable and then start the server with "pg_ctl start".
Yours,
Laurenz Albe