Update: This project is no longer maintained. I no longer work in an environment with PostgreSQL or Ganglia. It seems that updates are needed for this module to work with newer versions of PostgreSQL and I do not have the resources to test it. If you are interested in taking over this project, let me know and I will create a link to that project.
This is the Ganglia python module for PostgreSQL. It executes queries against the database to gather metrics for display in Ganglia.
Various other Ganglia python modules were used as a reference for this work.
More information on Ganglia python modules can be found here.
- The psycopg2 library. This is a PostgreSQL adapter for Python. Your OS distribution may have a package available which provides this adapter.
- The argparse library. This parses command line options. Your OS distribution may have a package available which provides this library.
- Copy
postgresql.pyconfto/etc/ganglia/conf.d/. - Copy
postgresql.pyto/usr/lib64/ganglia/python_modules - Configure the module.
- Restart the gmond service.
Similar to other Ganglia python modules, configuration is managed through a
configuration file in the pyconf directory /etc/ganglia/conf.d/. The file is
postgresql.pyconf.
In order to add metrics in addition to those already included, it is required
that the metrics_defs dictionary be modified in the module script
postgresql.py. This dictionary is where all the queries are defined and one
can use the included queries as a guideline for creating additional metrics.
- It is not yet clear which included metrics need to be GAUGE or COUNTER. This will be improved upon as they are discovered.
- This module was not thoroughly tested. More testing is in progress.
As with most Ganglia python modules, you can execute postgresql.py from the
command-line. Execute postgresql.py -h for help. The command-line invocation
is very close to how gmond will utilize the module.
-
Mail
bwong114 [at] gmail.com