tom.bakken at tx.usda.gov
Tue Sep 16 13:13:13 CDT 2003
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
then you need to point to the exact directory where the header file lives.
if it does:
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:
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