Psycopg psycopg

Comments and changes to this ticket

• 

  Daniele Varrazzo November 15th, 2012 @ 12:31 PM

  Hi, not getting your config. Win7 64 bit and you have Python 2.7 32 bit installed. Are you trying to install Psycopg 32 or 64 bit? I assume it must be 32 but it seems you are installing the 64 bit. Please clarify.

• You flagged this item as spam.
  

  chandramouli November 15th, 2012 @ 12:39 PM

  Hi Daniele ,

  I was trying out with both 64 as well as 32 bit versions..

  Both installers fail saying "Python2.7 is not found in the registry"

  Then I have unzipped them manually and placed them in C:\Python27 (my python instal dir)
  if i try to invoke psycopg2 it gives error "%1 is not win32 recognized command"

• 

  Daniele Varrazzo November 15th, 2012 @ 01:46 PM

  psycopg is not to be invoked: it's not a program, it's a library.

  For me it just sounds like a screwed up Python installation. I'll ask Jason to take a look at this ticket: I can't help you further with Windows.

• You flagged this item as spam.
  

  chandramouli November 15th, 2012 @ 04:25 PM

  thanks for you time Daniele,

  yeah invoking it is a dumb (desperate)attempt
  am using python code which has import Psycopg2 statement in it, which is failing..

• 

  Daniele Varrazzo November 15th, 2012 @ 04:35 PM

  I've asked Jason to take a look at your case, but if it is possible, I'd suggest you to uninstall all the Python installation instances from your machine and try re-installing python again.

  Unpacking the .exe (which you have already discovered it is a .zip) and copying manually the psycopg2 directory and its contained file _psycopg.dll into a PYTHONPATH directory should work as well, provided Python is correctly installed and the 32/64 bit option and Python version match.

• You flagged this item as spam.
  

  Jason Erickson November 15th, 2012 @ 08:50 PM

  A few questions come to mind:

  • Is your python 2.7 installed from the installation package at python.org?
  • Are you using virtualenv?
  • Are you using python from a 3rd party package (ie, like ArcGIS, ABACUS, etc)?

  The python.org installation sets up the registry keys in one of the two locations for your environment:

     HKEY_CURRENT_USER\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath
  

  Being that the psycopg2 installation is not finding the installation keys leads me to believe that there is something unusually with your setup.

  From your description (32bit Python 2.7), you would need the following psycopg2 package:

      http://www.stickpeople.com/projects/python/win-psycopg/psycopg2-2.4.5.win32-py2.7-pg9.1.3-release.exe
  

  Can you remove all instances of psycopg2 that you installed by hand and start the python interpreter?:

    C:\Python27\python.exe
  

  And issue the following in the python interpreter:

    import psycopg2
  

  We should see the following error (We want it to fail at this point)

    ImportError: No module named psycopg2
  

  If we don't, it means that python is attempting to install psycopg2 from another location and you will have to remove those files. What I am looking for is that python is not grabbing psycopg2 from somewhere else, and that we are starting from a clean slate.

  Once we are at this point, we can extract the files by hand. Using a program like 7zip, open up the above psycopg2 installation package. Go into the PLATLIB directory. At this point, there will be a psycopg2 directory and a psycopg2-2.4.5-py2.7.egg-info file. The "psycopg2" directory should be extracted and placed in the "C:\Python27\lib\site-packages" directory.

  Start the python interpreter again and issue the import psycopg2, this time it should be successful with importing the module. (Fingers crossed).

  If you are still having problems, issue the following commands at the python interpreter and let me know the output:

    import sys
    sys.version
  

• 

  Daniele Varrazzo November 24th, 2012 @ 10:58 PM

  • State changed from “new” to “invalid”