License | Overall Build | |||
---|---|---|---|---|
TimescaleDB | PostgreSQL 10 | PostgreSQL 11 | PostgreSQL 12 | PostgreSQL 13 |
1.5.1 | ||||
1.6.1 | ||||
1.7.4 | ||||
Latest |
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 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
This tech stack that needs to be installed in the following order:
- graphite - Viewing Hardware Stats Database and Intermeadite Viewing.
- collectd - Collecting Hardware Stats and store into the graphite database.
- timescaledb - PostgreSQL TimescaleDB database for storing PostgreSQL Live stats and Log Stats.
- pg_readlog - Collecting PostgreSQL Log Stats and store into the TimescaleDB database.
- pg_monitor - Collecting PostgreSQL Live Stats and store into the TimescaleDB database.
- grafana - Viewing All Stats from the TimescaleDB database and the graphite database. (Final View)
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.