perl dbi:pg

Started by Josephalmost 25 years ago5 messagesgeneral
Jump to latest
#1Joseph
lters@mrtc.com

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

#2Noname
newsreader@mediaone.net
In reply to: Joseph (#1)
Re: perl dbi:pg

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.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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

#3Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Joseph (#1)
Re: perl dbi:pg

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

#4Joseph
lters@mrtc.com
In reply to: Brett W. McCoy (#3)
RE: [GENERAL] perl dbi:pg

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:pg

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#5Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Joseph (#4)
RE: [GENERAL] perl dbi:pg

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