Submitted by:Egor Puzanov

Description:

This ZenPack provides monitoring of PostgreSQL databases. There is a PgSqlDatabase components template and a community.sql.PgSqlDatabaseMap collector plugin that the device will need to use.

The ZenPack provides the following performance graphs:

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

Screenshots:

REQUIREMENTS:

Zenoss Version: 2.5, 3.0

ZenPack Dependencies:

• RDBMS Monitoring
• SQL Data Source

External Dependencies:

• Requires either PostgreSQL ODBC driver or pg8000 DB-API 2.0 interface.
• PostgreSQL ODBC Driver registered with name "PgSQL". The following zProperties need configuration:
  • zPgSqlConnectionString - Connection String
  • zPgSqlPorts - TCP ports list
  • zPgSqlUsername - username
  • zPgSqlPassword - password
  • zPgSqlDatabaseIgnoreNames - databases to ignore
  • zPgSqlDatabaseIgnoreTypes - databases types to ignore

Installation: Install all dependencies in order

Source: https://github.com/epuzanov/ZenPacks.community.PgSQLMon

Tagged Releases:

• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/pgsql-odbc-1.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/pgsql-odbc-2.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/pgsql-odbc-2.1
• https://github.com/epuzanov/ZenPacks.community.PgSQLMon_ODBC/tree/pgsql-odbc-2.2
• https://github.com/epuzanov/ZenPacks.community.PgSQLMon/tree/pgsqlmon-2.5

Change History:

• 1.0 initial release
• 2.0 converted to Zenoss 2.5 and use of either ODBC driver or pyodbc
• 2.1 Zenoss 3.0 support
• 2.2 fix modeler plugin, split performance templates, sql queries optimization
• 2.5 switch from ODBC data source to SQL data source

Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1

Known issues: