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

downloaded language package for python, perl and tcl , but same problem existing — Rahul Gour, Jan 03 '18 at 13:52
see https://stackoverflow.com/questions/35210979/postgresql-unable-to-create-plpythonu-extension — Jan, Dec 17 '19 at 16:12

score 3 · Accepted Answer · answered Jan 31 '18 at 13:04

3

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:

answered Jan 31 '18 at 13:04

Andrius V.

3

where to find this information ? like for plpython3u which python version is required ? – Abhijit Gujar Jun 03 '19 at 08:26
2

for PostgreSQL 13 it is Python 3.7 – orangecaterpillar Feb 15 '21 at 00:49
> Where to find this information ? Like for plpython3u which python > version is required ? Answer: C:/Program Files/PostgreSQL/[version]/doc/installation-notes.html – Francis Fulgencio Jul 17 '20 at 14:02
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: https://stackoverflow.com/questions/21001890/installing-plpythonu-on-windows – Dr Ian Gregory Feb 07 '23 at 08:53

1 Answers1