I think I've tried every combination of postgres 9.4 and 9.5 and psycopg2 and python. I've used Dependency Walker to examine dlls and read countless web pages. My current error is "ERROR: could not load library "C:/Program Files/PostgreSQL/9.4/lib/plpython3.dll": The specified procedure could not be found." Many people have encountered this error and there seems to be no shortage of "solutions". So my question is, does anybody have a clean set of instructions on how to get python working on a windows install of postgres; any version. I'm flexible, I can start fresh, I don't care which versions, I don't care if it's 32 bit or 64 bit. I just want to try it out.
How did you install Postgres and from what source?
Hi, I installed postgres from http://www.postgresql.org/ . I have version 94 and 95 installed and running on my windows 7 machine in 64 bit. I use pgAdmin and these installs are running with no problems. I get the aforementioned error message when I execute: " CREATE EXTENSION plpython3u SCHEMA pg_catalog VERSION "1.0";'
Also when I try "CREATE PROCEDURAL LANGUAGE 'plpython3u', same result.Dependency walker shows a dependency on PYTHON33.DLL and there is no such file as that either in /lib or /bin. So, according to various "solution", I should be able to download this missing DLL . I've not done this yet because 1) it seems suspicious that a DLL is missing from the install and 2) I don't tend to trust sites that offer free DLLs. Virus city.
Do not play in Windows much, but I believe you have to use the StackBuilder that is installed along with with the database. Select it and then look for the Language Pack section.
Another, recently announced option(though it means uninstalling your current cluster, I believe):
