Re: install on windows

From: Jason Erickson <jerickso(at)stickpeople(dot)com>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Levente <leventelist(at)gmail(dot)com>, "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: Re: install on windows
Date: 2016-03-23 18:55:43
Message-ID: CAFpJua3CvdZL1BPwmbWXoUEk8T8vYJPCAhAtctBN8YjTH9qBeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hmm, I can duplicate this issue. But investigating it more, it is not
strictly a psycopg2 issue, either.

As Levente noted, the installers use Windows registry keys to determine the
location of the Python installation. Between python 3.4.x and 3.5.x, it
looks like the registry key for 32bit Python was changed from a format of
3.5 to 3.5-32.

This change causes a problem for ALL 32bit extension installers on Python
3.5 that use the standard Python stub installer.

Briefly looking at the stub code, I believe the standard Python stub
installer only recognizes registry keys in the format <major>.<minor>. The
extra '-32' at the end of the registry key makes the installer ignore the
key, never finding the Python installation.

Another package that uses the Python stub installer, pycurl, exhibits the
same issues:

https://bintray.com/artifact/download/pycurl/pycurl/pycurl-7.43.0.win32-py3.5.exe

I'm not suggesting this, but a workaround is to rename the following
registry key from:

SOFTWARE\WOW6432Node\Python\PythonCore\3.5-32

to:

SOFTWARE\WOW6432Node\Python\PythonCore\3.5

(ie, remove the '-32')

Install the extension, and then rename the registry back. Don't forget to
rename it back!

Another workaround is to use the 64bit version of Python and Extensions.

-jason

On Wed, Mar 23, 2016 at 7:11 AM, Daniele Varrazzo <
daniele(dot)varrazzo(at)gmail(dot)com> wrote:

> On Wed, Mar 23, 2016 at 12:06 PM, Levente <leventelist(at)gmail(dot)com> wrote:
> > Ummm...
> >
> >
> > This is on the website:
> >
> >
> http://www.stickpeople.com/projects/python/win-psycopg/2.6.1/psycopg2-2.6.1.win32-py3.5.exe
> >
> > Lev
>
> Ok right: I thought you were trying to use 'pip install'. In this case
> I don't know what's going on with your registry; someone else may.
>
> -- Daniele
>
>
> --
> Sent via psycopg mailing list (psycopg(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/psycopg
>

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Carlos Correia 2016-03-31 01:06:58 Export data to XLS
Previous Message Daniele Varrazzo 2016-03-23 13:11:06 Re: install on windows