could not load library plpython3.dll

Question

I am getting an error while creating an extension in Postgresql version 10

could not load library "C:/Program Files/PostgreSQL/10/lib/plpython3.dll": The specified module could not be found

CREATE EXTENSION plpython3u;

Note: Using Postgresql 10 on Window 10

Briny

downloaded language package for python, perl and tcl , but same problem existing – Briny

see #35211479 – Contusion

Answer 1

I have struggled a lot with this. For me only worked when I installed the right version of python and added paths to environment variables.

Try version python-3.4.0.amd64 for windows 64bit or other versions from this Python 3.4.0 downloads Link

Environment variables to add:

• C:\Python34\Scripts
• C:\Python34\

Laylalayman

where to find this information ? like for plpython3u which python version is required ? – Stevie

> Where to find this information ? Like for plpython3u which python > version is required ? Answer: C:/Program Files/PostgreSQL/[version]/doc/installation-notes.html – Harquebus

for PostgreSQL 13 it is Python 3.7 – Kauri

The Postgres installation notes may be wrong. Such as for Postgres ver.15. Python3.10 NOT 3.9 is required. Use dependency walker as per this solution: #21002390 – Jonathonjonati