Re: Trouble installing psycopg2

From: Augori <augori(at)gmail(dot)com>
To:
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trouble installing psycopg2
Date: 2013-09-27 11:45:20
Message-ID: CAFE+72MWUKQYjOeLA3U6ddywWB74=gbEamjp6YszZ65Q7DbrCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

*Thanks again for the suggestions. It doesn't look to me like it's
installed in /usr/local/lib/python2.7/site-packages. There's an egg
directory there, but otherwise, no psycopg2. The egg directory doesn't
mean it's installed, does it?? Here's an ls of that site-packages dir:*

root(at)server [/usr/bin]# ls /usr/local/lib/python2.7/site-packages
./ setuptools-0.6c11-py2.7.egg-info
../ setuptools.pth
distribute-0.6.35-py2.7.egg/ stevedore-0.12-py2.7.egg/
easy-install.pth virtualenv-1.9.1-py2.7.egg/
psycopg2-2.5.1-py2.7-linux-x86_64.egg/ virtualenv_clone-0.2.4-py2.7.egg/
README virtualenvwrapper-4.1.1-py2.7.egg/
setuptools-0.6c11-py2.7.egg

*If I modify my sys.path, it still doesn't import psycopg2. The python
command runs version 2.7.5 and you can see that in evidence in the sys
path. It is looking at a different Python 2.7 that I installed under
opt/bin and added to the PATH variable when I was trying to set up a
virtualenvwrapper. *

Here's a Python session:

root(at)server [/usr/bin]# python
Python 2.7.5 (default, Sep 25 2013, 10:45:19)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-54)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sys
>>> sys.path
['', '/opt/lib/python27.zip', '/opt/lib/python2.7',
'/opt/lib/python2.7/plat-
linux2', '/opt/lib/python2.7/lib-tk', '/opt/lib/python2.7/lib-old',
'/opt/lib
/python2.7/lib-dynload', '/opt/lib/python2.7/site-packages']
>>> sys.path.append('usr/local/lib/python2.7/site-packages')
>>> import psycopg2
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named psycopg2

*But I can't get psycopg2 to install to the 2.7.5 directory. Its
site-packages is completely empty:*

root(at)server [/usr/bin]# ls /opt/lib/python2.7/site-packages
./ ../ README

*whereas, /usr/lib64/python2.4/site-packages/ is full of stuff, including
psycopg2. I've pasted just a small portion of the ls results below.*
*
*
root(at)server [/usr/bin]# ls /usr/lib64/python2.4/site-packages/*
*

ortableServer.py* xf86config.py
_gamin.a PortableServer.pyc* xf86config.pyc
_gamin.la* PortableServer.pyo* xf86config.pyo
gamin.py psycopg2/

*I also tried appending this path and importing. That gives a different
error --tries to import it but fails, probably because it's inside a 2.4
install:*

root(at)server [/usr/bin]# python
Python 2.7.5 (default, Sep 25 2013, 10:45:19)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-54)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sys
>>> sys.path
['', '/opt/lib/python27.zip', '/opt/lib/python2.7',
'/opt/lib/python2.7/plat-
linux2', '/opt/lib/python2.7/lib-tk', '/opt/lib/python2.7/lib-old',
'/opt/lib
/python2.7/lib-dynload', '/opt/lib/python2.7/site-packages']
>>> sys.path.append('/usr/lib64/python2.4/site-packages/')
>>> import psycopg2
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib64/python2.4/site-packages/psycopg2/__init__.py", line 69,
in
<module>
from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: /usr/lib64/python2.4/site-packages/psycopg2/_psycopg.so:
undefin
ed symbol: PyUnicodeUCS4_Decode

Do you have other ideas?

Thanks.

On Thu, Sep 26, 2013 at 11:52 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 09/26/2013 07:07 PM, Augori wrote:
>
>> I think Python 2.4 was installed with the OS. I installed Python 2.7
>> from an .egg file that I downloaded. I'm a bit new to this
>> terminology, so not sure if that considered Centos package management.
>>
>
> No.
>
>
>
>> I think you're right about Python2.4 being set as the default. Does
>> anyone know how to persuade it otherwise for installation purposes?
>>
>
> Well it seems you already have psycopg2 installed for Python 2.7, it just
> cannot find it. Here is a possible solution.
>
> Open the Python 2.7 shell
>
> import sys
>
> then
>
> sys.path
>
> This will show a list of paths that Python 2.7 knows about. Look to see if
> /usr/local/lib/python2.7/site-**packages/ is listed.
>
> If not, you can temporarily include it by doing:
>
> sys.path.append('/usr/local/**lib/python2.7/site-packages/')
>
> and then
>
> import psycopg2
>
> If it is indeed installed in /usr/local/lib/python2.7/site-**packages/ it
> should load.
>
> To make the change 'permanent' create a *.pth file in one of the
> directories shown when you first did sys.path, preferably a site-packages
> one. In the file put '/usr/local/lib/python2.7/**site-packages/ . Then
> name the file, say usr_local.pth. Python adds directories in *.pth files to
> the sys.path.
>
> Thanks.
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-27 14:16:09 Re: Building with MinGW issue
Previous Message Arjen Nienhuis 2013-09-27 08:37:26 Re: ENUM drop label workaround