Thread

1. perl dbi:pg

   Joseph <lters@mrtc.com> — 2001-04-10T10:29:15Z

   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
   
   
   

2. Re: perl dbi:pg

   newsreader@mediaone.net — 2001-04-10T12:08:36Z

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

3. Re: perl dbi:pg

   Brett W. McCoy <bmccoy@chapelperilous.net> — 2001-04-10T13:11:03Z

   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
   
   
   

4. RE: [GENERAL] perl dbi:pg

   Joseph <lters@mrtc.com> — 2001-04-10T23:12:14Z

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

5. RE: [GENERAL] perl dbi:pg

   Brett W. McCoy <bmccoy@chapelperilous.net> — 2001-04-11T01:47:03Z

   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