How can I install DBD::Pg if postgres is not installed?

Question

I have a separate servers running with postgres and Nagios. I want to use "psql_replication_check.pl" with nagios to monitor the postgres replication status. This check script requires DBD::Pg module to connect to database. Installation of DBD::Pg asking for the path of pg_config file.

#perl Makefile.PL 
Configuring DBD::Pg 2.17.1
Path to pg_config? 

I don't have permissions to install postgres on Nagios machine. Is there anyone who has fixed this issue before.

I have CentOS 5.4 on both systems.

Answer 1

What you need in order to install DBD::Pg isn't all of PostgreSQL, but only the C client library, libpq. The package containing the header files for that will also include the pg_config program. On most Debian-based systems, that package is called libpq-dev - other vendors will have other names for it.