ZenPacks.community.PgSQLMon

About

This project is Zenoss extension (ZenPack) that makes it possible to model and monitor PostgreSQL databases.

Requirements

Zenoss

You must first have, or install, Zenoss 2.5.2 or later. This ZenPack was tested against Zenoss 2.5.2, Zenoss 3.2 and Zenoss 4.2. You can download the free Core version of Zenoss from http://community.zenoss.org/community/download.

ZenPacks

You must first install

• SQLDataSource ZenPack
• RDBMS Monitoring ZenPack

External dependencies

You can use pyisqldb module provided by SQLDataSource ZenPack, or install ONE of the DB-API 2.0 compatible modules for PostgrSQL database. Module can be installed with easy_install-2.6 command as zenoss user.

• pyisqldb - DB-API 2.0 compatible wrapper for isql command from unixODBC. PostgreSQL ODBC driver must be installed and registered with name "PostgreSQL".

  zPgSqlConnectionString example:

  'pyisqldb',DRIVER='{PostgreSQL}',host='${here/manageIp}',port='${here/port}',database='${here/dbname}',user='${here/zPgSqlUsername}',password='${here/zPgSqlPassword}',ansi=True
  

• pyodbc - DB-API 2.0 compatible interface to unixODBC. PostgreSQL ODBC driver must be installed and registered with name "PostgreSQL".

  zPgSqlConnectionString example:

  'pyodbc',DRIVER='{PostgreSQL}',host='${here/manageIp}',port='${here/port}',database='${here/dbname}',user='${here/zPgSqlUsername}',password='${here/zPgSqlPassword}',ansi=True
  

• pg8000 - DB-API 2.0 compatible Pure-Python interface to the PostgreSQL database engine.

  zPgSqlConnectionString example:

  'pg8000.dbapi',host='${here/manageIp}',port=${here/port},database='${here/dbname}',user='${here/zPgSqlUsername}',password='${here/zPgSqlPassword}',socket_timeout=10,ssl=False
  

• psycopg - DB-API 2.0 compatible interface to the PostgreSQL database engine.

  zPgSqlConnectionString example:

  'psycopg2',host='${here/manageIp}',port=${here/port},database='${here/dbname}',user='${here/zPgSqlUsername}',password='${here/zPgSqlPassword}'
  

Installation

If you have an old version (ZenPacks.community.PgSQLMon_ODBC) of this ZenPack installed, please uninstall it first.

Normal Installation (packaged egg)

Download the PgSQLMon ZenPack. Copy this file to your Zenoss server and run the following commands as the zenoss user.

zenpack --install ZenPacks.community.PgSQLMon-2.6.egg
zenoss restart

Developer Installation (link mode)

If you wish to further develop and possibly contribute back to the PgSQLMon ZenPack you should clone the git repository, then install the ZenPack in developer mode using the following commands.

git clone git://github.com/epuzanov/ZenPacks.community.PgSQLMon.git
zenpack --link --install ZenPacks.community.PgSQLMon
zenoss restart

Usage

Installing the ZenPack will add the following items to your Zenoss system.

Configuration Properties

• zPgSqlConnectionString
• zPgSqlUsername
• zPgSqlPassword
• zPgSqlDatabaseIgnoreNames
• zPgSqlDatabaseIgnoreTypes

Modeler Plugins

• community.sql.PgSqlDatabaseMap

Monitoring Templates

• PgSqlDatabase

Performance graphs

PgSqlDatabase

• PostgreSQL Database Size
• PostgreSQL Connections
• PostgreSQL Transactions
• PostgreSQL Disk Read
• PostgreSQL Command Statistics
• PostgreSQL Scans Statistics
• PostgreSQL Block Requests
• PostgreSQL Toast Block Requests