Hallo Zabbix-Community!
I am currently occupied with the topic Database Monitoring for Postgres and to evaluate which System suits us best.
I already tried DBforBix which is really neat and works fine, except that sometimes the dbforbix service just stops and it won't poll the Databases till I restart it. I didn't find any problems in the log so far but i hope I can resolve it soon.
Second, I tried pg_monz, which is quite similiar to DBforBix with the difference that I use the Zabbix Agent to monitor my Databases. The only problem here is, that it sends the Select Statements one after another. I DIDN'T CHECK THIS YET, but in the logs i saw quite many authentication failures cause of the password for the DB and it didn't seem to be just a timeout for the first Query but for every Query another Failure (I already fixed that).
The next Step will be pgsnmpd, but I just don't find any good information about it! The only page I found so far was the project page itself (http://pgsnmpd.projects.pgfoundry.org/). The Project is quite old, with its last release in 2007 but I think it should still be able to monitor our Postgres 9.2.4!
I did the compile parts described on the page (after installing several dev packages) and did the pgsnmpd_regress.pl with only one small issue:
Now my question!
I started the pgsnmpd with
!
What is this problem about?
Further I can't poll any of the OIDs which should come with the pgsnmpd!
I hope there is someone in this forum who can help me with this problem!
Br Manuel
Ps:
pgsnmpd.conf.3:
I am currently occupied with the topic Database Monitoring for Postgres and to evaluate which System suits us best.
I already tried DBforBix which is really neat and works fine, except that sometimes the dbforbix service just stops and it won't poll the Databases till I restart it. I didn't find any problems in the log so far but i hope I can resolve it soon.
Second, I tried pg_monz, which is quite similiar to DBforBix with the difference that I use the Zabbix Agent to monitor my Databases. The only problem here is, that it sends the Select Statements one after another. I DIDN'T CHECK THIS YET, but in the logs i saw quite many authentication failures cause of the password for the DB and it didn't seem to be just a timeout for the first Query but for every Query another Failure (I already fixed that).
The next Step will be pgsnmpd, but I just don't find any good information about it! The only page I found so far was the project page itself (http://pgsnmpd.projects.pgfoundry.org/). The Project is quite old, with its last release in 2007 but I think it should still be able to monitor our Postgres 9.2.4!
I did the compile parts described on the page (after installing several dev packages) and did the pgsnmpd_regress.pl with only one small issue:
Code:
not ok 3 - geqo should be off # Failed test 'geqo should be off' # at pgsnmpd_regress.pl line 134. # got: undef # expected: 'off'
I started the pgsnmpd with
Code:
[root@zabbix pgsnmpd-1.0]# ./pgsnmpd -c pgsnmpd.conf.3 -C "host=localhost user=postgres" [init_smux] bind failed: Address already in use PGSQL-SNMP-Ver1.0 is up and running.
What is this problem about?
Further I can't poll any of the OIDs which should come with the pgsnmpd!
I hope there is someone in this forum who can help me with this problem!
Br Manuel
Ps:
pgsnmpd.conf.3:
Code:
com2sec readwrite default public group MyRWGroup v2c readwrite view all included .1 80 access MyRWGroup "" any noauth exact all all none agentaddress localhost:10161
Comment