perl dbi:pg
Any one care to share what it takes to get dbd:pg working?
I got the pgsql_perl5-1.9.0.tar.gz from CPAN.
I set the variables POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
and POSTGRES_INCLUDE=/path_to_/libpq-fe.h
However then it complains that it can't find postgres_ext.h
In file included from Pg.xs:16:
/install/postgresql/postgresql-snapshot/src/interfaces/libpq/libpq-fe.h:27:
postgres_ext.h: No such file or directory
make: *** [Pg.o] Error 1
respectfully,
Joseph
You got the wrong file if you want
dbd:pg
It's called
DBD-Pg-0.95.tar.gz
for my version
Also those environment variables should
be set to directory.
So you need LIB=.../lib
etc
Show quoted text
On Tue, Apr 10, 2001 at 06:29:15AM -0400, Joseph wrote:
Any one care to share what it takes to get dbd:pg working?
I got the pgsql_perl5-1.9.0.tar.gz from CPAN.
I set the variables POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
and POSTGRES_INCLUDE=/path_to_/libpq-fe.h
However then it complains that it can't find postgres_ext.hIn file included from Pg.xs:16:
/install/postgresql/postgresql-snapshot/src/interfaces/libpq/libpq-fe.h:27:
postgres_ext.h: No such file or directory
make: *** [Pg.o] Error 1respectfully,
Joseph---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
On Tue, 10 Apr 2001, Joseph wrote:
I got the pgsql_perl5-1.9.0.tar.gz from CPAN.
I set the variables POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
and POSTGRES_INCLUDE=/path_to_/libpq-fe.h
However then it complains that it can't find postgres_ext.h
POSTGRES_LIB and POSTGRES_INCLUDE must point to directories, not files.
Keep in mind that this is NOT DBD::Pg -- you are using the native Perl
interface. DBD::Pg is a different module on CPAN.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
Writing about music is like dancing about architecture.
-- Frank Zappa
Thanks for your help.
I think I got the right perl package now, however I still have a problem
compiling the DBD:pg
make
cc -c -I/install/postgresql/postgresql-snapshot/src/interfaces/libpq -I/usr/
local/lib/perl5/site_perl/5.6.0/i686-linux/auto/DBI -fno-strict-aliasing -I/
usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSI
ON=\"0.96\" -DXS_VERSION=\"0.96\" -fpic -I/usr/local/lib/perl5/5.6.0/i686-li
nux/CORE Pg.c
In file included from Pg.h:17,
from Pg.xs:13:
/install/postgresql/postgresql-snapshot/src/interfaces/libpq/libpq-fe.h:27:
postgres_ext.h: No such file or directory
make: *** [Pg.o] Error 1
DBD-Pg-0.96
This is the enviroment var:
POSTGRES_INCLUDE=/install/postgresql/postgresql-snapshot/src/interfaces/libp
q
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Brett W. McCoy
Sent: Tuesday, April 10, 2001 9:11 AM
To: Joseph
Cc: Pgsql-General
Subject: Re: [GENERAL] perl dbi:pgOn Tue, 10 Apr 2001, Joseph wrote:
I got the pgsql_perl5-1.9.0.tar.gz from CPAN.
I set the variables POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
and POSTGRES_INCLUDE=/path_to_/libpq-fe.h
However then it complains that it can't find postgres_ext.hPOSTGRES_LIB and POSTGRES_INCLUDE must point to directories, not files.
Keep in mind that this is NOT DBD::Pg -- you are using the native Perl
interface. DBD::Pg is a different module on CPAN.-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
Writing about music is like dancing about architecture.
-- Frank Zappa---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Tue, 10 Apr 2001, Joseph wrote:
DBD-Pg-0.96
This is the enviroment var:
POSTGRES_INCLUDE=/install/postgresql/postgresql-snapshot/src/interfaces/libp
q
This is still incorrect. Typically, POSTGRES_INCLUDE will point to
/usr/local/pgsql/include, and POSTGRES_LIB will point to
/usr/local/pgsql/lib, assuming you have PostgreSQL installed under
/usr/local/pgsql. If you installed via RPM, your PostgreSQL includes and
libraries may be under /usr/include and /usr/lib, respectively.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
You will find me drinking gin
In the lowest kind of inn,
Because I am a rigid Vegetarian.
-- G.K. Chesterton