Обсуждение: POSTGRES_INCLUDE and POSTGRES_LIB??

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 and with what values?  (I'm pretty new to Linux, and
the job of maintaining this server was an "emergency Undertaking".)
Below are details which should be helpful.

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

-------------------------------------------------------------------------------------
Installed on this 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>

(Note:  The DBI stuff installed seemingly flawlessly.)
-------------------------------------------------------------------------------------
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=undef
  Compiler:
    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=define
  Linker 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 Private, Free Email at http://www.hotmail.com

Building the latest version of DBI-pg requires you set
POSTGRES_INCLUDE and POSTGRES_LIB in your environment.
One way to do this is to add them to your .bash_profile
for the user doing the build.  Try something like the
following (adjust it for your path of course):

POSTGRES_INCLUDE=/usr/local/src/postgresql-6.5.3/src/include
POSTGRES_LIB=/usr/lib
                                    

I tried getting Perl DBI working through the plain vanilla RPM
install, but it just didn't work.  Works fine if you follow
the installation instructions and build from scratch.

Jambo!

Dan

Dan Rosner wrote:
> POSTGRES_INCLUDE=/usr/local/src/postgresql-6.5.3/src/include
> POSTGRES_LIB=/usr/lib

> I tried getting Perl DBI working through the plain vanilla RPM
> install, but it just didn't work.  Works fine if you follow
> the installation instructions and build from scratch.

What did and didn't work in building under the RPM install??  For the
RPM install, the above envvars should be:
POSTGRES_INCLUDE=/usr/include/pgsql
POSTGRES_LIB=/usr/lib

No, I didn't choose the locations -- that was chosen many PostgreSQL and
RedHat revisions ago, and changing them would be like the Great
Renaming.  Not something to relish.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11