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