Re: [GENERAL] plpythonu and PYTHONPATH/sys.path
On Tue, 6 Mar 2007, Korin Richmond wrote: On Tue, 6 Mar 2007, Richard Huxton wrote: Korin Richmond wrote: Hi, I want to use python modules I have written in plpythonu. I can load these modules in functions within postgres if they are installed in the "official" python module directories (e.g. /blah/site-packages etc.) However, I want to use modules which are in my home file space, but I can't get this to work. Does user "postgres" have access to your home directory? Sorry, yes, I forgot to mention I've checked it's not just a permissions problem by putting the module in /tmp, readable by everyone, and appending "/tmp" to sys.path in the function in the database. Still complains that the module can't be found though :( (If I fire up python as user postgres, I can import the module from /tmp.) Arrgh - apologies, I've just realised SELinux was the problem! Sorry to answer my own query - but thanks for your mail Richard, which set me on the right track again! regards, Korin -- = Dr. Korin Richmond Centre for Speech Technology Research 2 Buccleuch Pl, Edinburgh, EH8 9LW Tel: +44 (0)131 651 1769 http://www.cstr.ed.ac.uk/ssi/people/korin.html = ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] plpythonu and PYTHONPATH/sys.path
On Tue, 6 Mar 2007, Richard Huxton wrote: Korin Richmond wrote: Hi, I want to use python modules I have written in plpythonu. I can load these modules in functions within postgres if they are installed in the "official" python module directories (e.g. /blah/site-packages etc.) However, I want to use modules which are in my home file space, but I can't get this to work. Does user "postgres" have access to your home directory? Sorry, yes, I forgot to mention I've checked it's not just a permissions problem by putting the module in /tmp, readable by everyone, and appending "/tmp" to sys.path in the function in the database. Still complains that the module can't be found though :( (If I fire up python as user postgres, I can import the module from /tmp.) Korin -- = Dr. Korin Richmond Centre for Speech Technology Research 2 Buccleuch Pl, Edinburgh, EH8 9LW Tel: +44 (0)131 651 1769 http://www.cstr.ed.ac.uk/ssi/people/korin.html = ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] plpythonu and PYTHONPATH/sys.path
Korin Richmond wrote: Hi, I want to use python modules I have written in plpythonu. I can load these modules in functions within postgres if they are installed in the "official" python module directories (e.g. /blah/site-packages etc.) However, I want to use modules which are in my home file space, but I can't get this to work. Does user "postgres" have access to your home directory? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] plpythonu and PYTHONPATH/sys.path
Hi, I want to use python modules I have written in plpythonu. I can load these modules in functions within postgres if they are installed in the "official" python module directories (e.g. /blah/site-packages etc.) However, I want to use modules which are in my home file space, but I can't get this to work. I've tried setting PYTHONPATH to the directory containing the modules, and even tried explicitly appending the directory to sys.path within the plpythonu interpretter (i.e. at the beginning of the database function). I always get an import error, though - the module cannot be found. Why doesn't the embedded python interpretter use sys.path (fully?) for locating modules? How can I use python modules in plpythonu which are located in non-standard directories? (I use Fedora Core 6, Postgres v. 8.1.8, Python 2.4.4) Thanks, Korin -- = Dr. Korin Richmond Centre for Speech Technology Research 2 Buccleuch Pl, Edinburgh, EH8 9LW Tel: +44 (0)131 651 1769 http://www.cstr.ed.ac.uk/ssi/people/korin.html = ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
