How to upgrade Python version for PL/Python

Question

I have a Ubuntu 18.04 with Postgres 10 server running Python 3.5.2, PL/Python function works very well.

How can I upgrade PL/Python to 3.8.0

I used pyenv to install 3.8.0 under user 'postgres', I checked python version already 3.8.0, I even updated /etc/postgresql/10/main/environment to

PYTHONPATH= '/var/lib/postgresql/.pyenv/shims/python3'

But when I run PL/Python function

CREATE FUNCTION ptest ()
  RETURNS text
AS $$
  import sys
  return sys.version
$$ LANGUAGE plpython3u;

The result still 3.5.2

Did you restart postgres after making the change?

Jeremy
– Jeremy

2019-12-09 16:24:48 +00:00
Commented Dec 9, 2019 at 16:24 — Jeremy
– Jeremy, Commented Dec 9, 2019 at 16:24
yes, I did restart postgres

Xinzhou Liu
– Xinzhou Liu

2019-12-09 16:29:55 +00:00
Commented Dec 9, 2019 at 16:29 — Xinzhou Liu
– Xinzhou Liu, Commented Dec 9, 2019 at 16:29

jjanes · Accepted Answer · 2019-12-09 18:48:21Z

1

PostgreSQL's plpython extension needs to be compiled against the correct python header files. I doubt the header files are binary compatible between python 3.5 and 3.8. You will either need to recompile the PostgreSQL extension (or all of PostgreSQL) yourself, or find a package which ships the correctly compiled packages (which I doubt you will find).

The simple answer is, "don't do this". Why do you want to do this? If I were willing to build my own against a bleeding edge python, I would probably be doing it with a bleeding edge PostgreSQL, not the two year old version.

answered Dec 9, 2019 at 18:48

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DeepLogicNinja · Accepted Answer · 2021-07-31 17:19:17Z

0

To answer the question why.... Two Reasons:

Python 3.5 is EOL - https://www.python.org/downloads/release/python-350/
Some modules need > 3.5

I agree that you shouldn't "force" an upgrade if it's not supported by the Postgresql - PL/Python team yet.

To work around this... I've seen some folks use virtual environments inside of PL/Python. Trying to avoid going that route if I can, rather way for direct support from the Postgresql PL/Python team.

answered Jul 31, 2021 at 17:19

DeepLogicNinja

1

Collectives™ on Stack Overflow

How to upgrade Python version for PL/Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related