Thread: Pg.pm Install RedHat7.0 Help

Pg.pm Install RedHat7.0 Help

From
"Allan C Huffman"
Date:
Hello Everyone,

I'd like to say first of all that PostgreSQL is a terrific database.
Been using it under Solaris with Perl and Java and it runs great!

I have a little problem with Linux RedHat 7.0.  I can't seem to get
Pg.pm to compile.  As the README says I'm making it under the postgres
super user account.  (I had to change the ownership of /usr/local to
postgres though!)  DBI installed with no errors, but DBD does the
following.  You will note that I explicitly put in the
/usr/local/DBD-Pg-0.98 references so that the compile would find Pg.c
but to no avail....

Thanks for your time and help,

Sincerely,

Allan in Belgium
_________________________________________________________________________

[postgres@inventory www]$ env
PWD=/home/www
POSTGRES_INCLUDE=/usr/local/pgsql/lib:/usr/local/DBD-Pg-0.98:/usr/local/pgsql/inc

lude
QTDIR=/usr/lib/qt-2.2.0
MANPATH=:/usr/local/pgsql/man:/usr/local/pgsql/man
LESSOPEN=|/usr/bin/lesspipe.sh %s
KDEDIR=/usr
USER=postgres

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:

MACHTYPE=i386-redhat-linux-gnu
POSTGRES_LIB=/usr/local/pgsql/lib:/usr/local/DBD-Pg-0.98:/usr/local/pgsql/includeMAIL=/var/spool/mail/www

INPUTRC=/etc/inputrc
BASH_ENV=/home/www/.bashrc
LANG=en_US
COLORTERM=
DISPLAY=:0
LOGNAME=postgres
SHLVL=5
SHELL=/bin/bash
USERNAME=
HOSTTYPE=i386
OSTYPE=linux-gnu
HISTSIZE=1000
HOME=/home/postgres
TERM=xterm
PGDATA=/usr/local/pgsql/data

PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/pgsql/include:/usr/local/pgsql/bin:./:/usr/local/DBD-Pg-0.98

_=/usr/bin/env

[postgres@inventory www]$ cd /usr/local/DBD*

[postgres@inventory DBD-Pg-0.98]$ make
gcc -c -I/usr/local/pgsql/lib:/usr/local/pgsql/include
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"0.98\" -DXS_VERSION=\"0.98\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE  Pg.c
In file included from Pg.xs:13:
Pg.h:17:22: libpq-fe.h: No such file or directory
make: *** [Pg.o] Error 1
[postgres@inventory DBD-Pg-0.98]$