Re: [Pypgsql-users] Which sourcefiles needed?

[Gerhard H. <gh...@gh...>]

Dick Kniep wrote:
> Hi list,
> 
> We are developing a system with a central database and many clients. The
> server and all clients run Linux. The database runs on the central
> server (surprise, surprise). To run pyPgSQL on the clients, we need to
> install it on all clients (is that so?), but to compile it (on the
> client), it needs Postgresql files. My question is which files are
> needed, and where should I locate them...

I can't tell which files exactly are needed to build against 
PostgreSQL's libpq. Building pyPgSQL works best if you have the 
PostgreSQL header and libraries installed (and not just in a PostgreSQL 
source tree). For most Linux distributions, there are several PostgreSQL 
packages, in particular you'll need the development package.

It's called postgresql-dev under Debian and has similar names under the 
other distributions.

The correct paths should be picked up by setup.py automatically for most 
major distributions (Debian, SuSE, Redhat). If not, you'll have to fire 
up an editor with setup.py and

- set USE_CUSTOM = 1
- set include_dirs and library_dirs appropriately

HTH,

-- Gerhard