[PyGreSQL] Help with build on amd-64 linux

[Ken Southerland]

I have an AMD 64-bit platform running SuSE Linux 10 and am having the 
following problem using pygresql on it....

ken at saturn> python -c "import _pg.so"
Traceback (most recent call last):
  File "<string>", line 1, in ?
ImportError: libpq.so.4: cannot open shared object file: No such file or 
directory


I have compiled postgres myself (had to due to using postgis extension, or so 
it seemed like I had to), and it seems to be working just fine.  The pygresql 
build also seemed to go perfectly fine using the setup.py method.  (see 
output below).

So far I have tried adding the location of libpq.so.4 to my PYTHONPATH and 
that didn't work.  This is an error I usually see when the libraries are 
incompatible rather than the file not actually existing, so I'm guessing its 
something like that.

Any help would be greatly appreciated.  Thanks!

Thanks,

Ken


The output from the build process ....

# python setup.py build install
running build
running build_py
creating build
creating build/lib.linux-x86_64-2.4
copying pg.py -> build/lib.linux-x86_64-2.4
copying pgdb.py -> build/lib.linux-x86_64-2.4
running build_ext
building '_pg' extension
creating build/temp.linux-x86_64-2.4
gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -fmessage-length=0 -Wall 
-D_FORTIFY_SOURCE=2 -g -fPIC -Iinclude -I/usr/local/pgsql/include 
-I/usr/local/pgsql/include/server -I/usr/include/python2.4 -c pgmodule.c -o 
build/temp.linux-x86_64-2.4/pgmodule.o -O2
gcc -pthread -shared build/temp.linux-x86_64-2.4/pgmodule.o 
-L/usr/local/pgsql/lib -lpq -o build/lib.linux-x86_64-2.4/_pg.so
running install
running install_lib
copying build/lib.linux-x86_64-2.4/pg.py -> /usr/lib64/python2.4/site-packages
copying build/lib.linux-x86_64-2.4/_pg.so 
-> /usr/lib64/python2.4/site-packages
copying build/lib.linux-x86_64-2.4/pgdb.py 
-> /usr/lib64/python2.4/site-packages
byte-compiling /usr/lib64/python2.4/site-packages/pg.py to pg.pyc
byte-compiling /usr/lib64/python2.4/site-packages/pgdb.py to pgdb.pyc
-- 
------s----a----m----s----i----x------
--

Ken Southerland
Senior Consultant
Sam Six, Inc.

503-236-4288
http://www.samsix.com