Skip to content

Instantly share code, notes, and snippets.

View array-in-a-matrix's full-sized avatar
:shipit:
:trollface:

Array in a Matrix array-in-a-matrix

:shipit:
:trollface:
37 followers · 98 following
View GitHub Profile
@supix
supix / postgres_recovery.md
Last active March 24, 2025 12:46
Postgres error: Missing chunk 0 for toast value in pg_toast

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.

@rawsh
rawsh / readme.md
Last active November 2, 2024 04:29
Emulating BotW on PC with CEMU and Wii USB Helper
  • Download wii usb helper https://github.com/FailedShack/USBHelperInstaller/releases
  • Create emulation and games directory (Documents/CEMU/Games)
  • Download CEMU http://cemu.info/ and extract to emulation directory (Documents/CEMU/cemu)
  • Download CEMUhook and extract to the same directory https://cemuhook.sshnuke.net/
  • Launch wii usb helper and use vault.titlekeys.ovh as the title key site (database)
  • Search Breath Of the Wild and select Add, Add Update, and Add DLC then click download on the bottom left
  • Download the Cache from here and move it to the folder cemu/shaderCache/transferable With Vulkan backend you don't need a transferable shader cache.
  • Launch the cemu executable. Click input and Xinput then select the controller and map buttons. Set CPU -> triple core recompiler in the top bar settings.
  • Click prepare game for emulation in Wii USB Helper then "Play this game on PC" (you can also add
@MaxXor
MaxXor / gpu-passthrough.md
Created October 29, 2017 14:47
Arch GPU Passthrough Summary

Arch Linux GPU-Passthrough

A quick guide on how to setup a GPU-Passthorugh. Below are some of my Resources

The Arch Wiki is the goto place for additional information and performance tweaks like CPU-Pinning.

Requirements

  • IGPU or second dedicated GPU for Host system (unless you want to go the hard way and use one GPU for HOST and GUEST)
@christopher-baek
christopher-baek / .Configure ddclient with Namecheap.md
Last active April 20, 2023 21:21
Configure ddclient withNamecheap

Configure ddclient with Namecheap

Namecheap Configuration

  1. Click the Manage button next to the domain in the Domain List view
  2. In the Domain tab, scroll down and remove any entries in the Redirect Domain list
  3. In the Advanced DNS tab...
  4. Turn on Dynamic DNS and make a note of the password
  5. Add an A Record for @ pointing to 127.0.0.1