[Nagiosplug-help] how to monitor postgresql

[Anjan Dave]

Installed the pg devel rpm as well, and it compiled fine then. The
check_pgsql plugin works now.

Thanks a lot Andreas!


-anjan

-----Original Message-----
From: Andreas Ericsson [mailto:ae at op5.se] 
Sent: Monday, November 15, 2004 1:34 PM
To: Anjan Dave
Subject: Re: [Nagiosplug-help] how to monitor postgresql

Anjan Dave wrote:
> Andreas,
> 
> I installed the libs package (and I'll get the devel also), which
> installs the libraries in /usr/lib, but looks like .configure doesn't
> find it, or it needs more?
> 

It needs the devel file and libraries. You'll also need to run ldconfig 
after having installed them (rpm should do this for you, but it doesn't 
hurt to stay safe).

> checking for PQsetdbLogin in -lpq... no
> configure: WARNING: Skipping PostgreSQL plugin (check_pgsql)
> configure: WARNING: LIBS="-lcrypt " CPPFLAGS=""
> configure: WARNING: install PostgreSQL libs to compile this plugin
(see
> REQUIREMENTS).
> 
> Thanks,
> Anjan
> 
> 
> -----Original Message-----
> From: Andreas Ericsson [mailto:ae at op5.se] 
> Sent: Monday, November 15, 2004 1:11 PM
> To: nagiosplug-help at lists.sourceforge.net
> Subject: Re: [Nagiosplug-help] how to monitor postgresql
> 
> Anjan Dave wrote:
> 
>>I have the check_pgsql.c in the original source-tree of the plugin,
> 
> but
> 
>>looks like it didn't get compiled...cause it needed the Postgresql
>>libraries...?
>>
> 
> 
> Libraries and header files.
> 
> 
>> 
>>
>>>From the REQUIREMENTS doc:
>>
>>check_pqsql:
>>
>>        - Requires the PostgreSQL libraries available from
>>          http://www.postgresql.org <http://www.postgresql.org/> 
>>
> 
> 
> There you have it. Download and install.
> 
> 
>> 
>>
>> 
>>
>>Which libraries are these? Is it
>>
>>postgresql-libs-7.4.6-2PGDG.i686.rpm
>>
> 
> 
> Yes, and most likely -devel also.
> 
> 
>>Does version of PG matter?
>>
> 
> 
> Obviously, to some extent. PG version 2 won't do, but a decently
recent 
> one should work ok.
> 
> 
>>Appreciate some help.
>>
> 
> 
> www.google.com should provide plenty of references to pages about 
> general hints regarding software compilation.
> 

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Lead Developer