Re: [GENERAL] using conda environment for plpython3u?

[Celia McInnis]

I am the server user. How do I make my conda environment available? It
seems as though plpython is using python 3.5.2, whereas my conda
environment is using python 3.6, and I don't have the modules loaded that I
need.

On Mon, Oct 23, 2017 at 5:42 PM, John R Pierce  wrote:

> 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
>

Re: [GENERAL] using conda environment for plpython3u?

[John R Pierce]

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

[GENERAL] using conda environment for plpython3u?

[Celia McInnis]

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, ...).