Re: using conda environment for plpython3u?

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 <pierce(at)hogranch(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>