Hi

I've tried to search the site, but no usable pages turned up.

My question is about monitoring PostgreSQL and if it turns out to be "down" 
to notify a person to take action.

I'm surprised that I couldn't find anything about it. Does anyone have an 
advice ? Anything that will fit into ordinary NMS. Maybe SNMP will not fit, 
but then some kind of "database ping", or equal.

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               ï¿½ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lï¿½rdag 11.00-17.00       Web:      www.suse.dk

Sun, 25 Feb 2001 20:06:15 +0100
Kaare Rasmussen <kar@webline.dk>
Monitor status
On Sun, 25 Feb 2001, Kaare Rasmussen wrote:

> Hi
>
> I've tried to search the site, but no usable pages turned up.
>
> My question is about monitoring PostgreSQL and if it turns out to be "down"
> to notify a person to take action.
>
> I'm surprised that I couldn't find anything about it. Does anyone have an
> advice ? Anything that will fit into ordinary NMS. Maybe SNMP will not fit,
> but then some kind of "database ping", or equal.

Have you looked at bigbrother?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Sun, 25 Feb 2001 22:33:45 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: Monitor status
Vince Vielhaber wrote:
> 
> On Sun, 25 Feb 2001, Kaare Rasmussen wrote:
> 
> > Hi
> >
> > I've tried to search the site, but no usable pages turned up.
> >
> > My question is about monitoring PostgreSQL and if it turns out to be "down"
> > to notify a person to take action.
> >
> > I'm surprised that I couldn't find anything about it. Does anyone have an
> > advice ? Anything that will fit into ordinary NMS. Maybe SNMP will not fit,
> > but then some kind of "database ping", or equal.
> 
> Have you looked at bigbrother?

There is also a component of netsaint (www.netsaint.org) that will
check PostgreSQL postmasters. I hope to add to that the ability to
do specific queries, (right now, it only does a login, then
disconnects). (I am the primary maintainer of the plugins that do
the actual service checks, another developer originated the overall
project and maintains the core software itself).

Netsaint, like big brother, can check a bunch of other services as
well. Nesaint has native support for notifications, and if you wish
cxan also be set upt to automatically issue restarts and so on (I
suspect Big Brother can do so also, but I do not know).

Netsaint is Free Software released under GPL.
__
Karl DeBisschop                       
kdebisschop@alert.infoplease.com
Learning Network Reference             http://www.infoplease.com
Netsaint Plugin Developer             
kdebisschop@users.sourceforge.net

Mon, 26 Feb 2001 09:08:35 -0500
kdebisschop@alert.infoplease.com
Re: Monitor status
> There is also a component of netsaint (www.netsaint.org) that will
> check PostgreSQL postmasters. I hope to add to that the ability to

Thanks.

I've also seen a lot of announcements of OpenNMS at freshmeat. All I know is 
that it's Java based, and as fas as I can tell will work without agents.

Can any of these operate in a mixed Linux / Win2000 environment (I'd like to 
have one tool only for NMS.

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               ���ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        L���rdag 11.00-17.00       Web:      www.suse.dk

Tue, 27 Feb 2001 00:49:41 +0100
Kaare Rasmussen <kar@webline.dk>
Re: Monitor status