Nagios and SQL -- bad combination?

[Marc Powell]

----Original Message----
From: Dhawal Doshy [mailto:dhawal at netmagicsolutions.com]
Sent: Friday, August 13, 2004 11:28 AM
To: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Nagios and SQL -- bad combination?

> Youngblood, Gregory (SAIC) wrote:
> 
> > Can someone clarify how Nagios uses the SQL database? Unless I'm
> > missing something, it appears data is updated in the database by
> > deleting all rows and inserting them again, for each test. That
> > can't be right, can it? 
> > 
> > 
> That is actually right.. nagios stores only the last service / host
> check results in the database. 
> 
> > Either something is wrong with my config (if so, I'd welcome any
> > corrections), or Nagios and SQL (Postgres) has a few issues.
> > 
> > 
> Marc Powell had earlier suggested using pgsql triggers that'll copy
> the data to a history table on every insert / update. I could share
> the trigger with you with marc's permission (or marc could do it
> himself).   

Go right ahead if you have it handy. It'd take me some time to compile
the information again and I'm trying to finish another project that's
got me tied up right now.

--
Marc



-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null