PostgresSQL could not load library plpython3.dll

Question

I managed to install the plpython3u extention. But when I try to use a function that uses the extension I get:

ERROR:  could not load library "C:/Program Files/PostgreSQL/12/lib/plpython3.dll": unknown error 126 SQL state: 58P01

I'm using windows 10 and postgresql 12.

Answer 1

You can simply solve this problem by installing the right (preferable version is in between 3.5.x to 3.8.x ) version of python and add paths to environment variables.

Steps:

Download and install the latest python version from this Download latest python version 3.8.x

Add environment variable:

1. C:\Program Files\Python38\Scripts
2. C:\Program Files\Python38