使用 zenoss监控POSTGRESQL和MySQL问题的解决

使用和监控数据库安装，相见以前的博客内容

一、在的帮助下，解决了两者共存和postgresql不能显示datasize的问题。

二、解决两者共存问题的方法

1. add community.odbc.PgSqlDatabaseMap modeler pluging to 'Modeler Plugins' list and model your server.

2. Lock Postgress databases and Server instances from deletion

3. remove community.odbc.PgSqlDatabaseMap modeler pluging

4. add community.odbc.MySqlDatabaseMap modeler pluging to 'Modeler Plugins' list and model your server.

5. Lock MySQL databases and Server instances from deletion

三、解决postgresql不能显示datasize问题的方法

1.modify PgSqlDatabaseMap.py 36 line

"SELECT datname as dbname, pg_database_size(datname) as totalBlocks FROM pg_database;"""

to

"SELECT datname as dbname, pg_database_size(datname)::float as totalBlocks FROM pg_database;"""

2. modify dmd/Devices/Server/rrdTemplates/PgSqlDatabase/sizeUsed

SELECT pg_database_size(datname) as sizeUsed  FROM pg_database WHERE datname='${here/dbname}';

to

SELECT pg_database_size(datname)::float as sizeUsed, datname FROM pg_database WHERE datname='${here/dbname}';