could not load library plpython3.dll

问题:

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

回答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\