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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] Fax: (312) 850-3930 Web: http://www.moyergroup.com ======================================================= ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
