APM: Pg.pm

Tom Bakken tom.bakken at tx.usda.gov
Tue Sep 16 13:13:13 CDT 2003

Tom Bakken

-----Original Message-----
From: erik at debill.org [mailto:erik at debill.org] 
Sent: Tuesday, September 16, 2003 11:03 AM
To: Tom Bakken
Cc: austin-pm at pm.org
Subject: Re: APM: Pg.pm

On Tue, Sep 16, 2003 at 10:19:14AM -0500, Tom Bakken wrote:
> I think the problem may be with my environmental variables.  The 
> pgsql_perl5 readme file says that I need an environmental variable 
> named POSTGRES_INCLUDE and POSTGRES_LIB to find the library libpq.so 
> and the include file libpq-fe.h.  I found libpg.so in /usr/lib so I 
> set POSTGRES_INCLUDE to /usr/lib and POSTGRES_LIB to 
> /usr/include/pgsql for libpq-fe.h.

I'd grep for libpq-fe.h in Pg.xs and see what it asks for.  If it does

#include <libpq-fe.h>

then you need to point to the exact directory where the header file lives.
if it does:

#include <something/libpq-fe.h>

you need the location of that "something" directory (my Debian stable box
with stock postgres packages has them in
/usr/include/postgresql/libpq-fe.h)  Odds are it's doing:

#include <postgresql/libpq-fe.h>

and I'd set POSTGRES_INCLUDE=/usr/include

>>I modified the Pg.xs file and that eliminated the complaint.  Also changed
the POSTGRES_INCLUDE to >>/usr/include.  It compiled, but I still get the

>>Perl: error in loading shared libraries:
/usr/local/lib/perl5/5.8.0/auto/Pg/Pg.so: undefined symbol: >>Perl_safefree.

Philip Molter thought I should recompile.  Now that I've succeeded and I
still get the same error, I'm.  Stumped.  When I run make test, I do get an
error: Pg::connectdb.....not ok: connectDB() == connect() failed: Connection
refused because it's trying to connect to postgres on the local server when
I've moved it over to another.  I wouldn't thing that would be a problem.
I've googled the error and found a number of posts there I'm looking into.

Does this get any closer?

Yes... Just don't know how far there is left to go.

I appreciate the help.


Consumerism:  the one true path to world peace.

More information about the Austin mailing list