how to install python3 in postgres

144 views Asked by At

I'm trying to work with plpython in postgresql So I run the command:

CREATE EXTENSION plpython3u

but I get the error:

Erro SQL [58P01]: ERROR: could not load library "C:/Program Files/PostgreSQL/15/lib/plpython3.dll": unknown error 126

I read some solutions like this: solution

but none of them helped me. I checked if the DLL exists in the postgres directory, and it is present in the directory

I'm using Windows 11, I have the latest version of Python installed on my computer, and also the environment variables are installed correctly, what could be causing this error? I'm using dbeaver

Edit 1

I followed a Languge package installation toturial from this link: EDB Docs

I also installed the correct version of Python as described in this postgresql document:

C:/ProgramFiles/PostgreSQL/15/doc/installation-notes.html

I added a system/user environment variable called PYTHONHOME% with the path:

C:\edb\languagepack\v3\Python-3.10

but I still get the same error as above.

I also added all the python environment variables (when installing python it already gives the option to install automatically)

0

There are 0 answers