Skip navigation
Currently Being Moderated

PostgreSQL

VERSION 4  Click to view document history
Created on: Sep 14, 2009 1:31 PM by jmartin - Last Modified:  Nov 9, 2009 11:05 PM by Matt Ray

Submitted by:

James Martin


Description:

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).

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.

     

    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:

    Attachments:
    Note: binary attachments ending in .zip will need to be unzipped before use.
    Comments (3)