PostgreSQL

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 issues have been reported 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).

Make sure you have enabled Statistic Collector in Postgres (postgresql.conf), check the PostgreSQL documentation.

Create new User in PostgreSQL any user has access to Statistic Tables.

Try to connect remotely under this user to postgres by running the following example:

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.

File Name	Zenoss Dependency	Linux Distro
ZenPacks.LearningObjects.PostgresqlMonitor-1.0-py2.4.egg	2.2	n/a

[return: ZenPack Project Site]