mjf

#! /bin/sh

# dockercat - Print Docker config or secret object
# Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/>
# Released under the terms of the "MIT License"

PROGRAM="${0##*/}"

if [ $# -eq 0 -o $# -ne 2 ]; then
  echo "Usage: $PROGRAM { config | secret } OBJECT" >&2

mjf

#! /bin/sh

[ $# -eq 1 ] && {
  grep -B 11 'KernelPageSize' "/proc/$1/smaps" |
  awk '/^Size:/ { sum += $2 } END { printf("%.2F GiB\n", sum / 1024 / 1024) }'
} || {
  printf "Usage: %s PID\n" "${0##*/}" >&2
  exit 1
}

mjf

-- PL/PgSQL Functions for Promscale API Schema
-- Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/>
-- Released under the terms of "The MIT License"

-- LABEL VALUES FUNCTIONS
--
-- label_values([<metric>,] <label>[, <time from>[, <time to>]])
--
-- Where:
--   <metric>    is name of a metric

mjf

PromQL to SQL Idioms for Promscale

Legend

Variable	Meaning
METRIC	Metric name (i.e. cpu_usage_system)
NAME	Name for the metric value (corresponds to AS "NAME" in SQL)

mjf

How to Upgrade PostgreSQL 12 with TimescaleDB Extension Cluster Managed by Patroni to PostgreSQL 13 on CentOS 8 Stream

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

mjf

#! /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

mjf

#! /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"

mjf

#! /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

mjf

⚠️ WARNING
The ordering of listed projects or documents is random and has no connection to relevance or maturity levels!

Postgres

Extensions

Extension	Description
pgaudit	Postgres auditing extension

mjf

-- 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