"Mitch Vincent" <mitch@venux.net> writes:
> You need to compile PostgreSQL from source with -g ..
> ftp.postgresql.org is the main FTP, there are many mirrors. Look for the
> source tarball there..
>> Im currently using rpms
>> is there a way to just remove an rpm(the API one) and compile only that??
If you don't want to mess with removing the RPMs, you don't have to.
Build the source with -g, but don't install it. Instead, copy the
static libpq.a library (look in src/interfaces/libpq after building)
to your application directory, and force your app to link against it
instead of against the libpq.so that's in /usr/lib (or whereever the
RPMs installed it).
regards, tom lane