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 2 · Accepted Answer · answered Jan 31 '18 at 13:04

2

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

1 Answers1