Andersson007

#!/usr/bin/python3
# Copyright: (c) 2020, Andrew Klychkov (@Andersson007) <[email protected]>
# MIT License
#
# Requirements:
# 1. pip3 install PyGithub
# 2. GitHub access token
#
# Example:
# ./issue_copier.py -t your_github_token_here \

Andersson007

#!/usr/bin/python3
# pg_query_inform.py - shows or sends notification about slow
# or idle-in-transaction queries.
# (functionality will be added if necessary)
# use pg_query_inform.py -h to show syntax
#
# Author: Andrew Klychkov [email protected]
# Version: 0.2
# Date: 2019-10-02
# License: Copyleft free software

Andersson007

#!/usr/bin/python
# pgdump_check.py - checks postgres dump and
# sends mail notification about status and statistic
#
# Author: Andrey Klychkov [email protected]
# Version: 1.0
# Date: 2018-07-31
# Licence: Copyleft free software
# Requirements:
# * Python 2.6;

Andersson007

#!/usr/bin/python3
# space_stat.py - collects,  analyses and sends
# a mail notification about filesystem space situation
#
# Author: Andrey Klychkov aaklychkov
# Version: 1.0
# Date: 2018-07-26
# Licence: Copyleft free software
# Requirements: Python3+
#

Andersson007

#!/usr/bin/python
# pg_stat_growth_tables.py - Collects statistics
# about growth of table size, saves it to stat files,
# calculate stat and sends a mail notification that contents of:
# 1) top tables by size
# 2) top tables by 1 day growth (with a difference)
# 3) similar lists for 7 days and 30 days
#
# Also you can set up growth percentage threshold
# (GROWTH_PRSTG_ALERT in Main params section below).

Andersson007

#!/usr/bin/python
# schema_check.py -
#   Checks changes of a Postgresql database schema
# and send notifications about it.
#
# It may be critical for some cases
# (running logical replication, for example)
#
# Author: Andreyk Klychkov [email protected]
# Licence: Copyleft free software

Andersson007

#!/usr/bin/python
# print_bloat.py - Print top of bloated indexes with stat
# Author: Andreyk Klychkov [email protected]
# Licence: Copyleft free software
# Syntax: ./print_bloat.py <dbname>
# Date: 23-03-2018
#
# Requirements: python2+, psql and postgres (installed locally),
# run it as 'postgres' user
#

Andersson007

#!/usr/bin/python3
# pg_tbl_idx_stat.py - The script shows postgresql indexes
# of a passed table with their size and some table statistics
#
# Author: Andrey Klychkov [email protected]
# Date: 23-03-2018
# Licence: Copyleft free software
# Requirements: python3, psql and postgres (installed locally),
# run as 'postgres' user
#