POSTGRES_INCLUDE ???

pgsql-interfaces@postgresql.org

Dear Knowlegable People:

I was overcome with joy when Postgres installed on the server seamlessly.  That
doesn't seem to happen often with things I do.  However, when I tried to
install Pg.pm (by the "perl -MCPAN -e -shell" method), I ran into problems.
Part of the error message is:
"please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !".
Where/how do I do this?  (I'm pretty new to Linux, and the job of maintaining
this server was an "emergency overtaking" that I was stuck with.)  Below are
the details you request in your "if you have problems" comment.  I also included
details which might otherwise be helpful.  If you can pull my fat out of the
fire on this one, I'll appreciate it forever.

Thanx For Your Help,
Bill Tuck
wat@england.com

-------------------------------------------------------------------------------------
Installed on my server  (each done with rpm -i postgres(the_rest_of_the_filename).rpm

postgresql-server-6.5.3-1.i386.rpm
postgresql-6.5.3-1.i386.rpm
postgresql-devel-6.5.3-1.i386.rpm
postgresql-odbc-6.5.3-1.i386.rpm
postgresql-perl-6.5.3-1.i386.rpm
postgresql-test-6.5.3-1.i386.rpm

(these were downloaded from ftp://ftp.postgresql.org/pub/RPMS/redhat-6.x/)
-------------------------------------------------------------------------------------
Output of "perl -MCPAN -e -shell" session

cpan> install DBD::Pg
Going to read /shadow/.cpan/sources/authors/01mailrc.txt.gz
CPAN: Compress::Zlib loaded ok
Going to read /shadow/.cpan/sources/modules/02packages.details.txt.gz
Scanning cache /shadow/.cpan/build for sizes
Going to read /shadow/.cpan/sources/modules/03modlist.data.gz
Running make for MERGL/DBD-Pg-0.93.tar.gz
CPAN: MD5 loaded ok
Checksum for /shadow/.cpan/sources/authors/id/MERGL/DBD-Pg-0.93.tar.gz ok
DBD-Pg-0.93/
DBD-Pg-0.93/eg/
DBD-Pg-0.93/eg/ApacheDBI.pl
DBD-Pg-0.93/Changes
DBD-Pg-0.93/MANIFEST
DBD-Pg-0.93/Makefile.PL
DBD-Pg-0.93/Pg.h
DBD-Pg-0.93/Pg.pm
DBD-Pg-0.93/Pg.xs
DBD-Pg-0.93/README
DBD-Pg-0.93/README.win32
DBD-Pg-0.93/dbd-pg.pod
DBD-Pg-0.93/dbdimp.c
DBD-Pg-0.93/dbdimp.h
DBD-Pg-0.93/test.pl
Removing previously used /shadow/.cpan/build/DBD-Pg-0.93
 CPAN.pm: Going to build MERGL/DBD-Pg-0.93.tar.gz

Configuring Pg
Remember to actually read the README file !
please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !
Running make test Make had some problems, maybe interrupted? Won't test
Running make install Make had some problems, maybe interrupted? Won't install

cpan>
-------------------------------------------------------------------------------------
Output of perl -v

This is perl, version 5.005_03 built for i386-linux
(copyright notice printed below.)
-------------------------------------------------------------------------------------
Output of perl -V

Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform:   osname=linux, osvers=2.2.1-ac1,
archname=i386-linux  uname='linux porky.devel.redhat.com 2.2.1-ac1 #1 smp mon feb 1 17:44:44 est
 
1999 i686 unknown '   hint=recommended, useposix=true, d_sigaction=define   usethreads=undef useperlio=undef
d_sfio=undefCompiler:   cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux (egcs-1.1.2
 
release)   cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'   ccflags ='-Dbool=char -DHAS_BOOL
-I/usr/local/include'  stdchar='char', d_stdstdio=undef, usevfork=false   intsize=4, longsize=4, ptrsize=4,
doublesize=8  d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12   alignbytes=4, usemymalloc=n,
prototype=defineLinker and Libraries:   ld='cc', ldflags =' -L/usr/local/lib'   libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl-lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt   libc=, so=so, useshrplib=false, libperl=libperl.a Dynamic
Linking:  dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'   cccdlflags='-fpic', lddlflags='-shared
-L/usr/local/lib'

Characteristics of this binary (from libperl): Built under linux Compiled at Apr  6 1999 23:34:07 @INC:
/usr/lib/perl5/5.00503/i386-linux  /usr/lib/perl5/5.00503   /usr/lib/perl5/site_perl/5.005/i386-linux
/usr/lib/perl5/site_perl/5.005
 
-------------------------------------------------------------------------------------



__________________________________________________________________
Get your own free England E-mail address at http://www.england.com