Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Net-snmp-users mailing list
Net-snmp-users@xxxxxxxxxxxxxxxxxxxxx
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux