Sebastian Webber sebastianwebber

The problem

In some cases, it is possible that PostgreSQL tables get corrupted. This can happen in case of hardware failures (e.g. hard disk drives with write-back cache enabled, RAID controllers with faulty/worn out battery backup, etc.), as clearly reported in this wiki page. Furthermore, it can happen in case of incorrect setup, as well.

One of the symptoms of such corruptions is the following message:

ERROR: missing chunk number 0 for toast value 123456 in pg_toast_45678

This almost surely indicates that a corrupted chunk is present within a table file. But there is a good way to get rid of it.

Custom format for displaying bytes as kb, mb, gb or tb.

Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc

Here is one that I have been using:

[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

Forward GnuPG agent from macOS to Linux

On the remote machine

Run gpg once as your to create the directory structure

gpg --list-keys

For headless systemd based hosts

Verificações importantes

Verificações importantes
Crachás

	{
	inputs.nixpkgs.url = github:NixOS/nixpkgs/nixos-22.11;
	inputs.flake-utils.url = "github:numtide/flake-utils";

	outputs = { self, nixpkgs, flake-utils }:
	flake-utils.lib.eachDefaultSystem (system:
	let
	pkgs = import nixpkgs { inherit system; };
	in
	{

	# Install Ubiquiti Unifi Controller on Ubuntu 20.04.
	# As tested on a fresh install of ubuntu-20.04.1-live-server, August 22nd 2020.
	# Thanks to https://gist.github.com/tmuncks for posting the updated install steps.

	sudo apt update
	sudo apt install --yes apt-transport-https

	echo 'deb https://www.ui.com/downloads/unifi/debian stable ubiquiti' \| sudo tee /etc/apt/sources.list.d/100-ubnt-unifi.list
	sudo wget -O /etc/apt/trusted.gpg.d/unifi-repo.gpg https://dl.ui.com/unifi/unifi-repo.gpg

	#!groovy

	// imports
	import jenkins.model.Jenkins
	import jenkins.model.JenkinsLocationConfiguration

	// parameters
	def jenkinsParameters = [
	email: 'Jenkins Admin <[email protected]>',
	url: 'https://ci.jenkins.com:8083/'

	# Use envFrom to load Secrets and ConfigMaps into environment variables

	apiVersion: apps/v1beta2
	kind: Deployment
	metadata:
	name: mans-not-hot
	labels:
	app: mans-not-hot
	spec:
	replicas: 1

	case "$TERM" in
	screen*)
	alias psql='PAGER=vim_psql_pager psql'
	esac

	ssl = off
	maintenance_work_mem = 2GB
	work_mem = 2GB
	fsync = off
	synchronous_commit = off
	wal_level = minimal
	max_wal_senders = 0
	archive_mode = off
	wal_buffers = -1
	wal_writer_delay = 20ms