/pg_monitor

pg_monitor is a tech stack to monitor Hardware, PostgreSQL Live and PostgreSQL Logs

Primary LanguagePLpgSQLApache License 2.0Apache-2.0

pg_monitor

License Overall Build
GitHub Build Status
TimescaleDB PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13
Relative date Relative date Relative date Relative date
1.5.1 Build Status Build Status
1.6.1 Build Status Build Status
1.7.4 Build Status Build Status Build Status
Latest Build Status Build Status

pg_monitor is a entire tech stack to monitor your Hardware, PostgreSQL Live and PostgreSQL Logs in realtime.

You can use then use Grafana to display the combined stats from all three sources. I use RaspberryPI's to drive displays in my office.

PLEASE NOTE: This is not even alpha code at this time. Right now I am copying the files I use at work into this repository and writing direction for doing the install. Once I have a base working copy here, I will remove this note.

Download Repository

Download the pg_monitor repository. This will be needed for the instructions on each installation page.

cd ~
# Get the pg_monitor repositories
git clone https://github.com/LloydAlbin/pg_monitor.git

Installation Order

This tech stack that needs to be installed in the following order:

  1. graphite - Viewing Hardware Stats Database and Intermeadite Viewing.
  2. collectd - Collecting Hardware Stats and store into the graphite database.
  3. timescaledb - PostgreSQL TimescaleDB database for storing PostgreSQL Live stats and Log Stats.
  4. pg_readlog - Collecting PostgreSQL Log Stats and store into the TimescaleDB database.
  5. pg_monitor - Collecting PostgreSQL Live Stats and store into the TimescaleDB database.
  6. grafana - Viewing All Stats from the TimescaleDB database and the graphite database. (Final View)

TODO List

TODO List - This is a list of the items that I currently need to complete to make this beta ready. Some I need to write and others, I just need to publish.