Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

postgresql 9 plpython2.dll not found

I am trying to enable PL/Python2 in my postgresql database. My setup is as follows

windows 7 64-bit 
postgresql 9.2 64-bit

In the \lib folder i have plpython3.dll but no plpython2.dll which I need as a function I need to use was written in Python2.

I found a plpython2.dll on another forum but it was a 32-bit version (I used dependency walker to test what the dll required)

I have since tried postgresql 9.0 which only has plpython.dll (which when I follow these instructions Postgres database crash when installing plpython) and then I thried postgresql 9.1 and the plpython3.dll appeared.

In the documentation it states that "Users of binary packages might find PL/Python in a separate subpackage." But I cannot find any anywhere.

I have the correct Python in my PATH environment variable and have even copied the python26.dll into the \lib folder.

Does anyone know where I can find the plpython2.dll?

thanks

like image 622
tjmgis Avatar asked Mar 14 '26 06:03

tjmgis


1 Answers

There is extensive discussion at http://forums.enterprisedb.com/posts/list/2878.page

I am not sure I would try the unverified DLL download attached to one post, and certainly not on a production server. My sense from reading the link is that pl/python2 is NOT SUPPORTED on Windows PostgreSQL 9.x because these are built against Python 3.x

I could be missing something however.

like image 145
Chris Travers Avatar answered Mar 16 '26 19:03

Chris Travers