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