problems compiling pyscopg2 on RHEL4

Hi All,

I installed the following rpms:

postgresql-libs-7.4.19-1.el4_6.1
postgresql-devel-7.4.19-1.el4_6.1
postgresql-7.4.19-1.el4_6.1

And then installed psycopg2 as follows:

wget http://initd.org/pub/software/psycopg/psycopg2-2.0.12.tar.gz
tar xzf psycopg2-2.0.12.tar.gz
cd psycopg2-2.0.12
python2.6 setup.py install

However, it appears something went wrong:

# python2.6
Python 2.6.2 (r262:71600, Sep 25 2009, 12:03:16)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-10)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
 >>> import psycopg2
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
   File "/usr/local/lib/python2.6/site-packages/psycopg2/__init__.py", 
line 60, in <module>
     from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: 
/usr/local/lib/python2.6/site-packages/psycopg2/_psycopg.so: undefined 
symbol: PQserverVersion

Has anyone seen this and/or know how to fix it?

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk