Re: Python 3.2 XP64 and Numpy...

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Python 3.2 XP64 and Numpy...
Date: 2015-06-01 17:41:46
Message-ID: 556C995A.703@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivann Ruiz 2015-06-01 17:57:14 Is my standby fully connected?
Previous Message Rémi Cura 2015-06-01 17:02:47 Re: Python 3.2 XP64 and Numpy...