I'm trying to install the plpython3u extension in my postgresql with this command: CREATE EXTENSION plpython3u;
mas eu recebo este erro:
ERROR: could not load library "C:/Program Files/PostgreSQL/15/lib/plpython3.dll": unknown error 126
My postgresql is in version 15 and was installed from the EDB website. Reading the postgres documentation (found at: C:\Program Files\PostgreSQL\15\doc\installation-notes) I saw that version 15 of postgresql requires python 3.9
NOTE: On Windows we are keeping older Perl version
Perl 5.26
Python 3.9
Tcl 8.6
So I did that, I installed version 3.9 of Python, set the environment variables (both user and system) but the same error persisted
So I tried to install plpython through the Stack Builder language pack, and there I saw that it installed Python 3.10, and also set an environment variable called PYTHONHOME% with this path: C:\edb\languagepack\v3\ Python-3.10
In other words, something is probably wrong in the PostgreSQL documentation.
When I saw this I uninstalled python 3.9 (and all environment variables) and installed python 3.10 and added environment variables for both user and system, but the same error persisted
so I went to: "C:/Program Files/PostgreSQL/15/lib/plpython3.dll" to see if my plpython3.dll was present, AND IT IS PRESENT
Any idea what I can do? I really don't know what else to do to solve the problem
to summarize what I tried to do: read the version requested in installation-notes (I tried but it didn't work) install the version that appears in Stack Builder (but it didn't work) I also tried
copy the dll C:\Python\Python310\python310.dll to C:\Windows\System32\python33.dll (name changed from python310 to python33, I saw a guy on a forum who did this and it worked) and in my system32 python3 is also present