in reply to PostgreSQL/Perl

You need to set the two environment variables to point at
the postgres lib and include directory
    POSTGRES_INCLUDE=/usr/include/pgsql
    POSTGRESQL_LIB=/usr/lib
    export POSTGRES_INCLUDE POSTGRES_LIB
or 
    setenv POSTGRES_INCLUDE /usr/include/pgsql
    setenv POSTGRESQL_LIB /usr/lib

depending on your shell

[download]
The location of these directories will vary depending on how
you installed postgresql
Hope this helps

Replies are listed 'Best First'.
Re: Re: PostgreSQL/Perl
by Hanamaki (Chaplain) on Nov 02, 2001 at 21:45 UTC
    In my case it looks like:
    export POSTGRES_HOME=/usr/local/pgsql
export PGLIB=$POSTGRES_HOME/lib
export PGDATA=$POSTGRES_HOME/data
export LD_LIBRARY_PATH=$PGLIB
export PATH=/usr/bin:/usr/local/pgsql/bin:$PATH

    [download]
    inside .bashrc.

    Hanamaki
[reply]
[d/l]
Re: Re: PostgreSQL/Perl
by Anonymous Monk on Nov 02, 2001 at 21:30 UTC
    Can do those commands from anywhere or do they have to be done from inside the directories?
[reply]
      Usually you put these commands into .bashrc, .bash_profile or wherever your systems looks for Environmental variables. Of course you can type these command all the time you reboot your system, but that doesn't seem very comfortable.

      Hanamaki
[reply]
        Do these variables have to be set before
        I do make test and make install?
[reply]

In Section Seekers of Perl Wisdom