Hi
I've just stumbled across pgsnmpd. It works quite well,
though I haven't yet found a web-based monitoring
software that works well with pgsnmpd. The problem is
that pgsnmpd exportsa bunch of values _per_ database.
(The output of snmpwalk looks something like
PGSQL-MIB::pgsqlDbDatabase.1.1.3 = STRING: "postgres"
PGSQL-MIB::pgsqlDbDatabase.1.1.4 = STRING: "template0"
PGSQL-MIB::pgsqlDbDatabase.1.1.5 = STRING: "template1"
PGSQL-MIB::pgsqlDbDatabase.1.2.3 = STRING: "postgres"
PGSQL-MIB::pgsqlDbDatabase.1.2.4 = STRING: "postgres"
PGSQL-MIB::pgsqlDbDatabase.1.2.5 = STRING: "postgres"
PGSQL-MIB::pgsqlDbDatabase.1.3.3 = STRING: "UTF8"
PGSQL-MIB::pgsqlDbDatabase.1.3.4 = STRING: "UTF8"
PGSQL-MIB::pgsqlDbDatabase.1.3.5 = STRING: "UTF8"
PGSQL-MIB::pgsqlDbDatabase.1.4.3 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.4.4 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.4.5 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.5.3 = INTEGER: 21263
PGSQL-MIB::pgsqlDbDatabase.1.5.4 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.5.5 = INTEGER: 17043
PGSQL-MIB::pgsqlDbDatabase.1.6.3 = INTEGER: 976
PGSQL-MIB::pgsqlDbDatabase.1.6.4 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.6.5 = INTEGER: 4
PGSQL-MIB::pgsqlDbDatabase.1.7.3 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.7.4 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.7.5 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.8.3 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.8.4 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.8.5 = INTEGER: 0
PGSQL-MIB::pgsqlDbDatabase.1.9.3 = STRING: "3720 kB"
PGSQL-MIB::pgsqlDbDatabase.1.9.4 = STRING: "3760 kB"
PGSQL-MIB::pgsqlDbDatabase.1.9.5 = STRING: "3720 kB"
)
Most SNMP monitoring tools (like netmrg) allow you to
define graphs for custom oid - but they don't allow me
to say "Create a graph for every oid that matches a
certain pattern". Therefor, I'd need to manually create
one graph per database, which is tiresome...
So - does anyone know a good webapplication that does
snmp graphs?
greetings, Florian Pflug
