I have a program I built to do some work with files we receive on our FTP server (SuSE 9.0) and use them to make changes to a Postgresql database on another system. When I first ran it, I discovered that I did not have the DBD::Pg module I needed to interact with our database on it - my test server had no problems, but we didn't use postgres on the FTP server for anything previously.
Attempting to use CPAN to get the module in question returns an error, which I have attempted to copy in full (from the start of the error segment) below:
Code:
CPAN.pm: Going to build T/TU/TURNSTEP/DBD-Pg-2.19.3.tar.gz
Configuring DBD::Pg 2.19.3
PostgreSQL version: 70304 (default port: 5432)
POSTGRES_HOME: (not set)
POSTGRES_INCLUDE: /usr/include/pgsql
POSTGRES_LIB: /usr/lib
OS: linux
****************
WARNING! DBD::Pg no longer supports versions less than 7.4.
You must upgrade PostgreSQL to a newer version.
****************
Running make test
Make had some problems, maybe interrupted? Won't test
Running make install
Make had some problems, maybe interrupted? Won't install
Okay, turns out the FTP machine did have a copy of Postgres 7.3 on it. I didn't think that would be a big problem - I could simply download a more up-to-date copy of postgres and install it, and things would be good.
I've done so - from source install of Postgres 8.3.23, added the path to my $PATH variable, and verified that running psql shows as version 8.3.23. However, this version of Postgres installed to a different directory than the previous one did, and I think I've managed to miss something in the path settings - I'm still getting the same error as above in CPAN when I try to download the DBD::Pg module.
What do I need to do to alter the path settings, either of my own path variable or of CPAN's path searching, to have it point to the new version of Postgres (or whatever libraries it may want from that) instead of the old one?