-----Original Message----- From: Magnus Hagander [mailto:magnus@hagander.net] Sent: Tuesday, July 13, 2010 3:26 PM To: Thom Brown Cc: Duncavage, Daniel P. (JSC-OD211); pgsql-general@postgresql.org Subject: Re: [GENERAL] NASA needs Postgres - Nagios help
On Tue, Jul 13, 2010 at 20:10, Thom Brown <thombrown@gmail.com> wrote: > On 13 July 2010 17:14, Duncavage, Daniel P. (JSC-OD211) > <daniel.p.duncavage@nasa.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?