CYBERTEC PostgreSQL Logo

Updates for the pgwatch2 Postgres monitoring tool

09.2017 / Category: / Tags: |

It's been quite some time since I last wrote about our Open Source PostgreSQL monitoring tool called pgwatch2, but now there's again a reason for it - it got a lot better again! Updates for the pgwatch2 Postgres monitoring tool include multiple new feature updates per requests from users and also some bugfixes. So this is a quick overview of new stuff here.

First some words about pgwatch2 - it’s our relatively new (released in January) PostgreSQL monitoring tool, aiming to provide a nice balance between features / usability / out-of-the-box experience, concentrating on nice graphs using Grafana. The philosophy behind the software could be formulated as "simple but flexible". Basically, it tries to do the minimum itself and let other existing software components to do the rest. Users can also easily define their own metrics with SQL and graph them however they want. It’s especially good for ad hoc monitoring, as getting started with pgwatch2 is a one-liner thanks to Docker.

Below is a listing of new features so feel free to check out that latest version and let us know on GitHub if you're still missing something in the tool or are having difficulties with something. Any feedback would be highly appreciated!

Project GitHub link - here.
Version 1.2 full changelog - here.

Comments on updates to pgwatch for version 1.2

  • Add possibility to monitor all databases for a host automatically

Previously one had to add all databases manually for a multi-db cluster, but now when leaving the “DB name” empty all DB-s are fetched, with those already being monitored skipped. A tip – when not sure what databases are there, uncheck the “Enabled” flag to review/enable/delete the found DB-s in the second step.

  • Enable deletion of InfluxDB metrics data from the Web UI

Previously this was only possible if connecting to the InfluxDB yourself via command line for example. Note that when removing a Postgres database host from monitoring, the gathered metrics are not automatically dropped as metrics gatherers work in the background and will take a minute or two to stop, so that’s the reason for two separate buttons.

  • Enabling use of pre-existing Postgres/Grafana/InfluxDB installations from Docker

Previously this was only possible when running the metrics gatherer and the config UI as standalone components, now there are bunch of environment variables available for that. See the README for details.

  • A flag to disable monitoring of the “test” demo database

By default the demo database is there to make it easy for getting a first impression for new users, but for advanced users it could be tedious to remove the configuration and delete the metrics data from InfluxDB so now there a flag for that. Set NOTESTDB=1 for example to avoid monitoring the test DB.

  • Config store Postgres DB is now UTF-8 to avoid problems with “funny” Grafana dashboard names
  • Corrections and better documentation for the backup/restore script for Docker image upgrades. See README for more
  • Corrections to default dashboards

pgwatch2 provides out-of-the-box some sample dashboards to get going quickly but creating new ones is a point-and-click effort.

  • Latest Grafana and InfluxDB versions

Grafana 4.5.1 and InfluxDB 1.3.5.

 pgwatch2 is constantly being improved and new features are added. Learn more.

Screenshots

Overview dashboard

pgwatch2_overview

Overview dashboard light theme

pgwatch2_overview_light_theme

Configuring monitored databases

pgwatch2_overview_light_theme

5 responses to “Updates for the pgwatch2 Postgres monitoring tool”

  1. fantastic tool - thanks - im having a connection problem to a local db - ERRO main: could not start metric gathering for DB "BTPG10" due to connection problem: failed to set statement_timeout on BTPG10, query not tried - im sure this is simple config issue on my part but cant figure it out -

    • Ah you probably already created that Github issue about that - so yes, Github is a better place for such stuff...

  2. also , i noticed a difference - when i add the password of my db acct - once saved , it switches back to 3 * - the text states if left to default 3* password will not be changed - my password is 4 chr

    • Yes currently it's just a constant "***" for all passwords - basically they're write-only currently as a security feature.

  3. Thanks for writing this nice blog. Sql database security help to protect important data from the database and it barrier the harmful threat in the database.

Leave a Reply

Your email address will not be published. Required fields are marked *

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram