Submitted by:

James Martin

The PostgreSQL ZenPack has a dependency on the Python pgsql module. It was tested against a 8.3.x Postgres server and partially works with 8.2.x.

It only supports one database to be monitored per Zenoss device. If you need to monitor multiple databases, create a new Device. On the todo list is a modeler that will detect all your current databases and dynamically collect information for all of them (any help would be appreciated).

You'll need to open the PostgreSQL port your server uses on your firewall (default is 5432).

psql -h YOUR_POSTGRES_HOST -U monitor -W postgres

and try executing the following SQL:

select * from pg_stat_all_tables;

If you see a bunch of values, then your setup should work. When you're ready to monitor hit the "Create Local Copy" under your More->Device ->Templates for Postgresql. Enter your own values for PostgreSQL Username, PostgreSQL Database, and PostgreSQL Password.

Todo:

A modeler that will detect all your current databases and dynamically collect information for all of them (any help would be appreciated). More work could be done to clean up the 8.2.x support. The script will also probably break against 8.4 when it is released.

REQUIREMENTS:

     Zenoss Version: 2.4

     ZenPack Dependencies:

     External Dependencies:

     Installation:

The PostgreSQL ZenPack has a dependency on the Python pgsql module. It was tested against a 8.3.x Postgres server and partially works with 8.2.x.

Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.LearningObjects.PostgresqlMonitor

Tagged Releases:

     http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/postgresql-1.1

Change History:

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

Known issues: