Обсуждение: Install numpy to use within plpython3u in postgres 9.6 for Windows2012 (64 bit)

Поиск
Список
Период
Сортировка

Install numpy to use within plpython3u in postgres 9.6 for Windows2012 (64 bit)

От
PeterS
Дата:
I am trying to install numpy to use within plpython3u in postgres 9.6 for Windows 2012 (64 bit) but I run into dependency problems. 1) I have installed Postgres 9.6 from EnterpriseDB and the language pack, which installs Python 3.3. <- is there a way to install a newer version of Python? I have done CREATE EXTENSION plpython3u; and it works correctly. I tried to install python modules with: pip3.exe install numpy and python -m pip install --user numpy but numpy-1.12.1 returns an error: raise RuntimeError("Python version 2.7 or >= 3.4 required.") If I try to install an older version of numpy==1.10.4, there are a number of errors about blas and atlas and fortran compilers not being available - so I didn't pursue that avenue much further. 2) If I install Python 3.6 separately, when CREATing EXTENSION plpython3u, I get the ERROR: could not load library "C:/Program Files/PostgreSQL/9.6/lib/plpython3.dll": The specified module could not be found. The DLL *is* in that location, but the utility "depends" shows that it is compiled for python33 and not python36, and those dependencies are missing. Could I replace the plpython3.dll file somehow to get it to work with Python 3.6? Surely someone has installed numpy for plpython3u in postgres for Windows, but I could not find any solutions so far, so I'm reaching out to the experts. Thanks Peter