in reply to 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.

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.
      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
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
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.