Re: PostgreSQL/Perl

Hello,
I managed to get the perl Makefile.PL to work.
I tried make test but got an error stating that
libpg-fe.h could not be found.
I did a search for it and found it in
/usr/include/pgsql/lib

This is what my .bashrc looks like now.

# .bashrc

# User specific aliases and functions

alias rm='rm -i'
alias cp='cp -i'
alias mv='mv -i'
export POSTGRES_HOME=/var/lib/pgsql
export PGLIB=/usr/include/pgsql/lib
export PGDATA=$POSTGRES_HOME/data
export LD_LIBRARY_PATH=$PGLIB
export PATH=/usr/bin:/var/lib/pgsql/bin:$PATH

# Source global definitions
if -f /etc/bashrc ; then

. /etc/bashrc
fi

Am I doing something wrong?
D.

Comment on Re: PostgreSQL/Perl

Replies are listed 'Best First'.
Re: Re: PostgreSQL/Perl by Anonymous Monk on Nov 03, 2001 at 11:34 UTC
Hello, I've changed the .bashrc file because my lib path was wrong. make still can't find libpq-fe.h even though it is in /usr/include/pgsql New entry in to .bashrc export POSTGRES_HOME=/var/lib/pgsql export PGLIB=/usr/include/pgsql export PGDATA=$POSTGRES_HOME/data export LD_LIBRARY_PATH=$PGLIB export PATH=/usr/bin:/var/lib/pgsql/data: /var/lib/pgsql/data: /usr/include/pgsql:/bin:$PATH When I type env all the variables have the correct path names. As well, I don't seem to have a pgsql/bin directory anywhere Is this odd? Getting kind of confused here! Any help would be muchly appreciated. D.	[reply]
Re: Re: Re: PostgreSQL/Perl by Hanamaki (Chaplain) on Nov 03, 2001 at 19:53 UTC
Search for binaries like `createdb`, `createuser`, `psql`, etc. pp. If you cannot find them the chances that Postgresql is not installed are pretty high. If you got stuck just try to compile Postgres again, start postgres with the `postmaster` command, test wether Postgres is working by using `psql` from the shell; install "DBI" and "DBD::Pg" and become a member of Perlmonks. Once I tried RPM's but it didn't work out for me. Therfore I cannot say much about a RPM install. Hanamaki	[reply] [d/l] [select]
Re: Re: PostgreSQL/Perl by Hanamaki (Chaplain) on Nov 03, 2001 at 19:57 UTC
Did you do a `make` after `perl Makefile.PL`? Missing libraries are usually stated during the make process, but not while doing `make test`. Hanamaki	[reply] [d/l] [select]
Re: Re: PostgreSQL/Perl by jepri (Parson) on Nov 03, 2001 at 11:35 UTC
You can use the force command to ignore errors and install anyway. I had to do this once for PostGreSQL as well. However your linux distribution should have DBD::Pg as a rpm. Use your favourite rpm front end and search for 'Pg' and then install the right rpm. No compiling necessary. ____________________ Jeremy I didn't believe in evil until I dated it.	[reply]