WARNING - OLD ARCHIVES

This is an archived copy of the Xen.org mailing list, which we have preserved to ensure that existing links to archives are not broken. The live archive, which contains the latest emails, can be found at http://lists.xen.org/
   
 
 
Xen 
 
Home Products Support Community News
 
   
 

xen-users

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

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

<Prev in Thread] Current Thread [Next in Thread>