On 10/23/2017 2:05 PM, Celia McInnis wrote:
Is it possible for users to use their conda environment for plpython, complete with the modules that they have loaded in that environment? If so, what do I do?

I am running postgres 9.6.2 and would like to use a conda environment for python 3.6 which contrains a fair number of modules that I want to use (eg., regex, recordclass, pandas, ...).


plpython runs in the context of the server user, not the end user.   as long as you can maket his 'conda environment' available to that user, and it doesn't violate the single threaded design of a postgres connection, I dunno why not.

that said, everything you do in a PL is running in the process context of the core database server.   I'm very very hesitant to drag in large complex external systems, and would generally prefer to do that sort of thing in an app server context outside the DB server.



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to