Skip site navigation (1) Skip section navigation (2)

POSTGRES_INCLUDE and POSTGRES_LIB??

From: "Bill Tuck" <bill_tuck(at)hotmail(dot)com>
To: pgsql-ports(at)postgresql(dot)org
Subject: POSTGRES_INCLUDE and POSTGRES_LIB??
Date: 1999-12-04 16:01:53
Message-ID: 19991204210153.20202.qmail@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-ports
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(at)england(dot)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

pgsql-ports by date

Next:From: Daniel KalchevDate: 1999-12-05 14:06:27
Subject: Re: [GENERAL] memory
Previous:From: Jared PollisterDate: 1999-12-04 00:56:42
Subject: PostgreSQL successfully installed on FreeBSD 3.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group