Problems with psycopg2 on OS X 10.6

From: Jim Nasby <[email protected]>
Date: April 15, 2010 7:47:52 AM CDT
To: psycopg-IAPFreCvJWPBWskQ1e/[email protected]
Subject: Problems with psycopg2 on OS X 10.6

Has anyone been able to get psycopg2 to work out of macports? PgQ keeps telling me to install psyccopg2. It's installed, but I can't import it:

[email protected][6:49]~/src:79%sudo port install py26-psycopg2 +postgresql83
--->  Computing dependencies for py26-psycopg2
--->  Fetching py26-psycopg2
--->  Verifying checksum(s) for py26-psycopg2
--->  Extracting py26-psycopg2
--->  Applying patches to py26-psycopg2
--->  Configuring py26-psycopg2
--->  Building py26-psycopg2
--->  Staging py26-psycopg2 into destroot
--->  Installing py26-psycopg2 @2.0.14_0+postgresql83
--->  Activating py26-psycopg2 @2.0.14_0+postgresql83
--->  Cleaning py26-psycopg2
[email protected][6:49]~/src:80%python
Python 2.6.1 (r261:67515, Feb 11 2010, 00:51:29) 
[GCC 4.2.1 (Apple Inc. build 5646)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2
Traceback (most recent call last):
 File "<stdin>", line 1, in <module>
 File "build/bdist.macosx-10.6-universal/egg/psycopg2/__init__.py", line 69, in <module>
 File "build/bdist.macosx-10.6-universal/egg/psycopg2/_psycopg.py", line 7, in <module>
 File "build/bdist.macosx-10.6-universal/egg/psycopg2/_psycopg.py", line 6, in __bootstrap__
ImportError: dlopen(/Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so, 2): Symbol not found: _PQbackendPID
 Referenced from: /Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so
 Expected in: flat namespace
in /Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so
>>> ^D

What's up with the ~/.python-eggs directory??

BTW, this is not a 32 vs 64 bit issue AFAICT:

[email protected][6:55]~/src:85%file /opt/local/lib/postgresql83/libpq.dylib 
/opt/local/lib/postgresql83/libpq.dylib: Mach-O 64-bit dynamically linked shared library x86_64
[email protected][6:56]~/src:86%file ~/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so 
/Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so: Mach-O universal binary with 3 architectures
/Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so (for architecture i386):	Mach-O bundle i386
/Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so (for architecture ppc7400):	Mach-O bundle ppc
/Users/decibel/.python-eggs/psycopg2-2.0.14-py2.6-macosx-10.6-universal.egg-tmp/psycopg2/_psycopg.so (for architecture x86_64):	Mach-O 64-bit bundle x86_64

--
Jim C. Nasby, Database Architect                   [email protected]
512.569.9461 (cell)                         http://jim.nasby.net