NASA needs Postgres - Nagios help

-----Original Message-----
From: Magnus Hagander [mailto:magnus(at)hagander(dot)net]
Sent: Tuesday, July 13, 2010 3:26 PM
To: Thom Brown
Cc: Duncavage, Daniel P. (JSC-OD211); pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] NASA needs Postgres - Nagios help

On Tue, Jul 13, 2010 at 20:10, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> On 13 July 2010 17:14, Duncavage, Daniel P. (JSC-OD211)
> <daniel(dot)p(dot)duncavage(at)nasa(dot)gov> wrote:
>> We are implementing Nagios on Space Station and want to use
>>> PostgreSQL to store the data on orbit and then replicate that db on
>>> the ground. The problem is, most people use MySQL with Nagios. We
>>> need an addon to ingest Nagios data into PostgreSQL. It looks like
>>> the most reasonable implementation is to update the NDOUtils addon to
>>>support PostgreSQL. Does anyone have such an addon, or want to
write one?
>>>
>>>
>>>
>>>I'm the NASA project manager for the set of computers on Space
>>>Station and we plan to deploy this capability this year. If have to
>>>write our own addon, we will, but I'd rather use something already
out there.
>
> >This looks like it hasn't been worked on in a while, but is this any
>> use?: http://nagiosplugins.projects.postgresql.org/

>Those are plugins to monitor postgresql using nagios. For that, you
should realy be looking at check_postgres. I think what the OP is
looking for is a way to store Nagios metadata in >postgres, which is
something else.

Daniel,

Buried in the ./ndoutils-1.4b9/db/README is wording that suggests it
may just be a matter of modifying the .sql file. What happens if you
just try it?

Best,
Sean