Re: [Xen-users] SNMP AgentX subagent for Xen

["Brian A. Seklecki" <lavalamp@xxxxxxxxxxxxxxxxxxxxxx>]

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



_______________________________________________
Xen-users mailing list
Xen-users@xxxxxxxxxxxxxxxxxxx
http://lists.xensource.com/xen-users