| Flag | Meaning |
|---|---|
[---] |
Holds for nothing (i.e. work in progress) |
[M--] |
Holds exclusively for master |
[-S-] |
Holds exclusively for slave |
[--C] |
Holds exclusively for cluster management |
[MS-] |
Holds for both master and slave |
| #! /bin/sh | |
| # haproxy-pgsql-tcp-check - Generate HAProxy PostgreSQL TCP Check | |
| # Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/> | |
| # Released under the terms of "The MIT License" | |
| # | |
| # See https://www.postgresql.org/docs/current/protocol-message-formats.html | |
| if [ $# -lt 2 -o $# -gt 3 ]; then | |
| printf -- 'Usage: %s USER DATABASE ["leader"]\n' "${0##*/}" >&2 |
| #! /usr/bin/awk --exec | |
| # pingfmt - Format output of the ping(1) program | |
| # Copyright (C) 2012, 2021 Matouš J. Fialka, <https://mjf.cz/> | |
| # Released under the terms of The MIT License | |
| BEGIN { | |
| # ----- HELP SCREEN ----- | |
| help = help "Usage: pingfmt [-h|-help|-usage] [+[no][show]<opt>[=<val>]]\n" |
| #! /bin/sh | |
| # Script "memo" to move CentOS 8 to AppStream | |
| # Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/> | |
| # Released under the terms of "The MIT License" | |
| dnf update -y && \ | |
| dnf install -y centos-release-stream && \ | |
| dnf distro-sync -y |
⚠️ WARNING
The ordering of listed projects or documents is random and has no connection to relevance or maturity levels!
| Extension | Description |
|---|---|
pgaudit |
Postgres auditing extension |
| -- PostgreSQL Gimmicks | |
| -- Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/> | |
| -- Released under the terms of "The MIT License" | |
| -- 1. BEWARE USING BETWEEN OPERATOR WITH DATE AND TIME TYPES | |
| -- 1.1 INCORRECT | |
| -- Note: intervals are written in ISO 8601 format |
| #! /bin/sh | |
| # mysqlgrants - Lists all MySQL grants | |
| # Copyright (C) 2020 Matous Jan Fialka, <https://mjf.cz/> | |
| # Released under the terms of the MIT license | |
| mysql -B -N $@ -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS query FROM mysql.user"| | |
| sort -V| | |
| mysql $@| | |
| sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}' |
| # RPM specfile for Prometheus | |
| # Copyright (C) 2020 Matous Jan Fialka, <[email protected]> | |
| # Released under the terms of the "MIT License" | |
| Name : prometheus | |
| Version : 2.22.1 | |
| Release : 1%{?dist} | |
| Group : Network Servers | |
| License : ASL 2.0 | |
| Source : https://github.com/prometheus/%{name}/releases/download/v%{version}/%{name}-%{version}.linux-amd64.tar.gz |
| # RPM specfile for Prometheus Pushgateway | |
| # Copyright (C) 2020 Matous Jan Fialka, <[email protected]> | |
| # Released under the terms of the "MIT License" | |
| Name : pushgateway | |
| Version : 1.3.0 | |
| Release : 1%{?dist} | |
| Group : Network Servers | |
| License : Apache License 2.0 | |
| Source : https://github.com/prometheus/%{name}/releases/download/v%{version}/%{name}-%{version}.linux-amd64.tar.gz |
| # RPM specfile for Promscale Postgres extension | |
| # Copyright (C) 2020 Matous Jan Fialka, <[email protected]> | |
| # Released under the terms of the "MIT License" | |
| Name : promscale_extension | |
| Version : 0.1.1 | |
| Release : 1%{?dist} | |
| Group : PostgreSQL Database Server 12 PGDG | |
| License : Timescale License | |
| Source : https://github.com/timescale/%{name}/archive/%{version}.tar.gz#/%{name}-%{version}.tgz |