Обсуждение: How to control which Python interpreter Postgres uses?

Ni Ne <nineoften@hotmail.com> writes:
> How can I adjust my postgres settings to tell it which Python interpreter binary to use?

You'd have to recompile plpython against the particular libpython
you want to use.

            regards, tom lane

P {margin-top:0;margin-bottom:0;}

Would I recompile the plpython package or postgres itself?

---

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Monday, November 1, 2021 4:03 PM
To: Ni Ne <nineoften@hotmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to control which Python interpreter Postgres uses?

 

Ni Ne <nineoften@hotmail.com> writes:
> How can I adjust my postgres settings to tell it which Python interpreter binary to use?

You'd have to recompile plpython against the particular libpython
you want to use.

                        regards, tom lane

On Mon, Nov 01, 2021 at 08:52:27PM -0500, Ron wrote:
>    Why would recompiling Python affect what Postgresql points to?

 Not python, but plpython. The extension that adds python
as a server programming language to postgres.
> 
>    On 11/1/21 5:06 PM, Ni Ne wrote:
> 
>      Would I recompile the plpython package or postgres itself?
> 
>      ----------------------------------------------------------------------
> 
>      From: Tom Lane <tgl@sss.pgh.pa.us>
>      Sent: Monday, November 1, 2021 4:03 PM
>      To: Ni Ne <nineoften@hotmail.com>
>      Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
>      Subject: Re: How to control which Python interpreter Postgres uses?
>       
>      Ni Ne <nineoften@hotmail.com> writes:
>      > How can I adjust my postgres settings to tell it which Python
>      interpreter binary to use?
> 
>      You'd have to recompile plpython against the particular libpython
>      you want to use.
> 
>                              regards, tom lane
> 
>    --
>    Angular momentum makes the world go 'round.

On Mon, Nov 01, 2021 at 04:08:01PM -0700, Wells Oliver wrote:
>    Apologies if I'm misunderstanding, but you can specify a virtual env (so
>    any interpreter) as we did here:

 This  probably  wouldn't  allow access to the plpy server access
module. Only simplest stored procedures would  work  without  the
ability  to work with the database (and python version is usually
less of importance for such simple scripts).



>    CREATE FUNCTION slack (msg text)
>        RETURNS boolean
>    AS $$
>        hook = 'https://...'
>        activate_this = '/opt/python/env/bin/activate_this.py'
>        exec(open(activate_this).read(), dict(__file__=activate_this))
>        from slack_sdk.webhook import WebhookClient
>        import ssl
>        ssl_context = ssl.create_default_context()
>        ssl_context.check_hostname = False
>        ssl_context.verify_mode = ssl.CERT_NONE
>        webhook = WebhookClient(hook, ssl=ssl_context)
>        webhook.send(text=msg)
>        return True
>    $$ LANGUAGE plpython3u;
>    On Mon, Nov 1, 2021 at 3:06 PM Ni Ne <nineoften@hotmail.com> wrote:
> 
>      Would I recompile the plpython package or postgres itself?

[skipped]

On Mon, 2021-11-01 at 22:06 +0000, Ni Ne wrote:
> Would I recompile the plpython package or postgres itself?

PL/Python is part of PostgreSQL itself, so yes, you'd have to
build that from source.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com