Re: SNMP AgentX subagent for Xen
"Brian A. Seklecki" <[email protected]>
| Newsgroups | gmane.comp.emulators.xen.user,gmane.comp.db.postgresql.general,gmane.network.net-snmp.user |
|---|---|
| Message-ID | <1212414079.2876.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> |
On Mon, 2008-06-02 at 15:05 +0200, Alain Barthe wrote:
>
> Sounds like a fun project.
> I agree.
With PostgreSQL, a the agent can simply daemonize and talk to the
Postmaster using libpq and proper HBA. Everything in pg_catalog.* and
information_schema.* is already quantified in SQL data structures:
postgres=# \d pg_catalog.pg_tables;
View "pg_catalog.pg_tables"
Column | Type | Modifiers
-------------+---------+-----------
schemaname | name |
tablename | name |
tableowner | name |
tablespace | name |
hasindexes | boolean |
hasrules | boolean |
hastriggers | boolean |
postgres=# SELECT * from pg_catalog.pg_database limit 2;
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datconfig | datacl
----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+--------
postgres | 10 | 0 | f | t | -1 | 10818 | 34352041 | 1663 | |
nagios | 17056 | 0 | f | t | -1 | 10818 | 34352146 | 1663 | |
(2 rows)
~BAS