pohzipohzi

Here are some examples of how to setup clangd for a project

If the project:

• uses meson

meson setup <build_dir> generates a compilation database in <build_dir>/compile_commands.json. Since clangd automatically looks for the compilation database in build, we don't need to do anything else if build is the name of the build directory

meson setup build

pohzipohzi

git rebase -i --root
# change verbs for relevant commits to `edit`
while [ $? -eq 0 ]; do git commit --amend --reset-author --no-edit --allow-empty --date="$(git log -n 1 --format=%ad)" && git rebase --continue; done

pohzipohzi

This is a sample program that tests output on a panicking go program based on different GOTRACEBACK settings. There are several levels that control the amount of output generated - none, single, all, system - each with it's own aliases. More information can be found at https://golang.org/pkg/runtime/.

• env GOTRACEBACK=none go run main.go

This should give the same output as env GOTRACEBACK=0 go run main.go

panic: f3
exit status 2

pohzipohzi

#!/bin/sh
PORTS=($(seq 7001 1 7006))

# set up servers
rm -f appendonly.aof
rm -f dump.rdb
for i in ${PORTS[@]}
do
    rm -rf $i
    mkdir $i

pohzipohzi

Postgres Cheatsheet

pg_ctl

pg_ctl init -D cluster
pg_ctl -D cluster -l cluster/logfile start
pg_ctl -D cluster restart
pg_ctl -D cluster promote

pohzipohzi

#!/bin/bash

if [ $# -ne 1 ]; then
        echo "Usage : $0 <file to compress>"
        exit 1
fi

file=${1%%/}

tar c "$file" | lz4 -z - "$file.tar.lz4"

pohzipohzi

PostgreSQL Page Checksum Protection

This gist summarises a way to create corrupted databases. Most of the material is adapted from Luca's Article.

Setup the database

Create and start the server with data checksums enabled

initdb -k -D cluster

pohzipohzi

WAL-G PITR

This gist summarises a way to simulate point-in-time recovery (PITR) using WAL-G. Most of the material is adapted from Creston's tutorial.

Setup

First we initialize a database cluster

pg_ctl init -D cluster

pohzipohzi

pohzipohzi

package join

import (
	"fmt"
	"strings"
	"testing"
)

var (
	testData = []string{"a", "b", "c", "d", "e"}