Skip to main content

PostgreSQL service populator.

Project description

Tool: 2_check_and_report

Description:

This program performs some checks and return a report in case some of these checks fail: - The number of databases created is under a specific threshold parametrized through the -m argument. - The disk used by postgresql is not over a percentage of the total disk. The specific percentage is parametrized through the -p argument. - The number of connections stablished to the database is not over a percentage of the max connections value. The specific percentage is parametrized through the -c argument.

How to:

Note: The next commands are meant to be run in the same that directory in which this Readme.txt file is stored.

  • Disable any previously activated virtualenv:

$ deactivate

  • Setup environment:

$ ../../setup_env.sh

  • Enable virtualenv:

$ source venvs/2_check_and_report/bin/activate

  • Get the program help:

$ ./run -v

  • Run the tool (example):

This command checks: the amount of databases is less than 10, the percentage of partition disk used by postgresql is less than 0.2%, and the percentage of active connections to the postgresql service is less than 2.5%.

$ ./run.py -m 10 -p 0.2 -c 2.5

Project details


Release history Release notifications

This version
History Node

0.0.0

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
pg_check_and_report-0.0.0.tar.gz (3.8 kB) Copy SHA256 hash SHA256 Source None Jul 16, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page