Hey,
python is installed from official binary, 64 b for windows,
in C/Python32
I can't remember the argument, but it might be irrelevant.
The problem doesn't seem to be to install numpy, it works perfectly in the regular terminal.
The problem seems to be that postgres can't use correctly numpy.
I found no version of scipy installer for win 64 with python 3.2,
I tried several but not having the exact python version always end in failure.
The binaries you linked to are dependent on intel math kernel library, which I don't have.
Cheers,
Rémi-C
2015-06-01 19:41 GMT+02:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 06/01/2015 09:09 AM, Rémi Cura wrote:
Hey, thanks to help me with that.
I started fresh to have a truly reproducible process,
so you can have all information and rule out some error possibilities.
- Uninstall all python.
- Check that PythonPath doesn't exist anymore
- check that python doesn't exist anymore
- install python 3.2.5 64 bit from official python website into C/Python32
- Reload configuration for server.
- create plpython3u , create a python function, test it (show path)
* It works, python path is
'C:\\Windows\\system32\\python32.zip', 'C:\\Python32\\Lib',
'C:\\Python32\\DLLs', 'E:\\9.3\\data', 'C:\\Program
Files\\PostgreSQL\\9.3\\bin', 'C:\\Python32',
'C:\\Python32\\lib\\site-packages'
- Donwload latest numpy from website.
- ON antoher PC
So what is the Python setup on this machine?
* Compile numpy with visual 2008 , 64 bit
* Create an binary installer for windows (using python.exe setup.py
)with proper argument
The argument would be?
- On the server :
- install numpy with the compiled installer.
Best guess is that the numpy compilation you are doing on Machine A is not compatible with what you have installed on Machine B(the server).
Have you looked at this:
http://www.lfd.uci.edu/~gohlke/pythonlibs/
or
http://www.scipy.org/install.html--
- check that numpy is correctly installer in C:\Python32\Lib\site-packages
- using an external terminal, check that numpy works (import numpy -> OK)
- Now, define a plpython3u function containing "import numpy"
- Run the function --> error is
"ERREUR: ImportError: DLL load failed: Le module spécifié est
introuvable.",
which roughly translate to
"ERROR: ImportError : DLL load failed : the specified module couldn't
be found".
- Create a plpython3u function returning sys.path
the path is "C:\\Windows\\system32\\python32.zip', 'C:\\Python32\\Lib',
'C:\\Python32\\DLLs', 'E:\\9.3\\data', 'C:\\Program
Files\\PostgreSQL\\9.3\\bin', 'C:\\Python32',
'C:\\Python32\\lib\\site-packages"
numpy is in this path, in C:\\Python32\\lib\\site-packages
All user of the computer have all rights on the
C:\\Python32\\lib\\site-packages folder
- execute `import imp; imp.find_package('numpy')` within the
plpython3u function
-> returns "None, 'C:\\Python32\\lib\\site-packages\\numpy', ('',
'', 5)"
- create a helloworld module , put it next to numpy, try to call it
-> it gets called
I really don't see what I can do more.
Cheers,
Rémi-C
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
