Re: Application monitoring

Hi,

I've got experice with monitoring all kinds of serviers/services with Nagios
(www.nagios.org). I has some plugins to check webservers, postgresql etc.
And is you need any special test, you can write your own plugin (open a
webpage and check for a certain string or so).

We use i to monitor our customers servers (via nrpe en passive checks even
servers behind a nat/firewall).

Regards

Jean Huveneers

Xillion ICT Solutions B.V.
Marktplein 8
6243 BR Geulle
The Netherlands

tel: +31 (0)43 3659244
fax: +31 (0)43 3659249
gsm: +31 (0)6 456 44 357
www: www.xillion.nl
-----Original Message-----
From: Steve Lane [mailto:slane(at)moyergroup(dot)com]
Sent: dinsdag 4 november 2003 2:20
To: PGSQL List (E-mail)
Subject: [ADMIN] Application monitoring

Hi all:

We maintain a number of web-based applications that use postgres as the back
end. We recently had an unfortunate situation where the hosted server was
hacked and the client had some significant downtime. We proposed a custom
monitoring app, written in PHP, that would periodically monitor (for
example) the web server (Apache) and database (postgres) so that we’d know
more quickly when something happened.

The client responded that surely this problem of monitoring a
database-backed web app was a known, solved problem, and wanted to know what
other people did to solve the problem.

So my question, hopefully not too off-topic: if you administer a
mission-critical postgres install that needs high availability, what do you
do for monitoring? Commercial, freeware or open source tool? Custom scripts?
Anything I haven’t thought of?

-- sgl

=======================================================
Steve Lane

Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607

Voice: (312) 433-2421 Email: slane(at)moyergroup(dot)com
Fax: (312) 850-3930 Web: http://www.moyergroup.com
=======================================================