PGObserver Setup

  • First make sure you have downloaded the project from GIT:
    $ git clone git@github.com:zalando/PGObserver.git
  • Create schema from sql/schema.sql where you want to store your data.
  • Copy pgobserver.conf to the home folder: ~/.pgobserver.conf
  • Configure .pgobserver.conf to match your setup:
    1. set database where to store data.
    2. set hostgroup for gatherer.
  • 3. configure usernames and passwords.
  • Create an unprivileged PostgreSQL user on the database you want to monitor.
  • Add entry to monitor_data.hosts table to include the databases you want to monitor.
    Use host_group to decide which gatherer monitors which cluster.
  • Build a single jar including dependencies using mvn clean verify assembly:single.
  • Start monitoring with: java -jar target/PGObserver-Gatherer-1.0-SNAPSHOT-jar-with-dependencies.jar.
  • For CPU load created the stored procedure from sql/cpuload.sql, this is a plpythonu function.

If you need help or find problems please post on the Project Issues page: https://github.com/zalando/PGObserver/issues