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
[EMAIL PROTECTED]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
