Skip to main content

Script for monitoring PostgreSQL databases with InfluxDB

Project description

pgflux

pgflux is a Python utility to send PostgreSQL metrics to InfluxDB. The drivers when developing this tool were:

It enables Grafana visualisations as seen in the screenshots below:

https://raw.githubusercontent.com/post-luxembourg/pgflux/v1.0.0.post1/docs/_images/grafana-dashboard-01.png https://raw.githubusercontent.com/post-luxembourg/pgflux/v1.0.0.post1/docs/_images/grafana-dashboard-02.png https://raw.githubusercontent.com/post-luxembourg/pgflux/v1.0.0.post1/docs/_images/grafana-dashboard-03.png

Installation

The project is currently very much usable but not officially released yet (no PyPI packages).

It is however installable via git or http directly:

pip install "git+https://github.com/exhuma/pgflux@initial-release"

Usage

See https://exhuma.github.io/pgflux/usage.html

Development & Extending

For detailed instructions, see https://exhuma.github.io/pgflux/development.html

NOTE

This project uses fabric as task runner (see https://fabfile.org). To install it use either pipx install fabric (recommended) or, if you don’t have pipx: pip install --user fabric.

Commands

  • Listing all available development tasks:

    fab -l
  • To set up or refresh the development environment:

    fab develop
  • Run PostgreSQL, InfluxDB & Grafana containers (requires docker-compose):

    fab run-dev-containers
  • Run the tests:

    fab test

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

pgflux-1.0.0.post2-py3-none-any.whl (19.1 kB view details)

Uploaded Python 3

File details

Details for the file pgflux-1.0.0.post2-py3-none-any.whl.

File metadata

  • Download URL: pgflux-1.0.0.post2-py3-none-any.whl
  • Upload date:
  • Size: 19.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/57.4.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.9.7

File hashes

Hashes for pgflux-1.0.0.post2-py3-none-any.whl
Algorithm Hash digest
SHA256 53bd719fd02e78a6c64c7892850ff9d014ff3e6713f331da654e62711da1c860
MD5 ccf19e8f63c4aa1af5f573aa42995a5d
BLAKE2b-256 3dc79744c0416440c7b5e4d404c0cd6f6ef97076909ea992b850e54eb2daad4d

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page