mjf

#! /bin/sh

# Encode and decode Crockford's BASE32
# Copyright (C) 2022 Matous Jan Fialka, <https://mjf.cz/>
# Released under the terms of the "MIT" license

# DO NOT USE FOR ANY REASON! This was just for some quick testing.

use() {
	printf -- '%s -d <enc> | <dec>\n' "${0##*/}"

mjf

with
  /* first generate random metric serie for past 1 day, 360 per hour */
  series as
  (
    select
      cast(
        now() - '1 day'::interval + n*'10 seconds'::interval
        as timestamp with time zone
      ),
      n*random()::double precision

mjf

Postgres blogs

(Persons are alphabeticaly sorted by family name, the rest is sorted by name.)

Personal

• Mark Andruth
• Lætitia Avrot
• Haki Benita
• Josh Berkus

mjf

set background=dark

hi clear
if exists('syntax_on')
 syntax reset
endif

let g:colors_name = 'mjf'

hi Normal ctermfg=250

mjf

set cmd:prompt '\U \S\n$ '
set ftp:port-range 21000-21999
set ftp:sync-mode off
set ssl:verify-certificate off

debug 4

alias ledit 'local edit'
alias lls 'local ls'
alias nocertverify 'set ssl:verify-certificate off'

mjf

#! /bin/sh
# DIP - Docker IP (petite tool to list container IP addresses)
# Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz>
# Released under the terms of the "MIT License"

printf -- '%-12s  %-47s  %-15s\n' 'CONTAINER ID' 'NAME' 'IP ADDRESS'
printf -- '------------  '
printf -- '-----------------------------------------------  '
printf -- '---------------\n'

mjf

-- Create login role, schema and security definer function for PgBouncer
-- Copyright (C) 2021 Matous Jan Fialka, <https://mjf.cz/>
-- Released under the terms of the "MIT License"

-- PER CLUSTER

CREATE ROLE
   pgbouncer
WITH
   LOGIN

mjf

cp [email protected] /etc/systemd/system
systemctl daemon-reload
systemctl enable [email protected]
cp rclone@restic /etc/sysconfig
vi /etc/sysconfig/rclone@restic
systemctl start rclone@restic
journalctl -xefurclone@restic

mjf

#! /bin/sed -f
# anna - Annonymize IPv4 and IPv6 addresses
# Copyright (2020) Matous Jan Fialka, <https://mjf.cz/>
# Released under the terms of the "MIT License"

# See RFC 5737 for the replacements explanation.
s/\(\(\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)\.\)\{3\}\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)\)/192.0.2.1/g
s/\(\([0-9a-f]\{1,4\}:\)\{6\}\(\([0-9a-f]\{1,4\}:[0-9a-f]\{1,4\}\)\|\(\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)[.]\)\{3\}\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)\)\|::\([0-9a-f]\{1,4\}:\)\{5\}\(\([0-9a-f]\{1,4\}:[0-9a-f]\{1,4\}\)\|\(\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)[.]\)\{3\}\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)\)\|\([0-9a-f]\{1,4\}\)\?::\([0-9a-f]\{1,4\}:\)\{4\}\(\([0-9a-f]\{1,4\}:[0-9a-f]\{1,4\}\)\|\(\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)[.]\)\{3\}\([0-9]\|[1-9][0-9]\|1[0-9]\{2\}\|2[0-4][0-9]\|25[0-5]\)\)\|\(\([0-9a-f]\{1,4\}:\)\?[0-9a-f]\{1,4\}\)\?::\([0-9a-f]\{1,4\}:\

mjf

# HAProxy TCP Binary Check for Postgres Replica Instance
# Copyright (C) "2021" Matous Jan Fialka, <https://mjf.cz/>
# Released under the terms of "The MIT License"

# https://www.postgresql.org/docs/current/protocol-message-formats.html

backend postgres

    bind :5432