ads' corner

How to determine the mount point for a device on Linux

While reinstalling a server and moving it to Debian, I ran into the problem that I need to sync the EFI partitions. The system is using a RAID on two disks, but the EFI partitions can't be a RAID and need to exist on both disks. Or rather it is useful to have the EFI partition on every disk: if one disk fails, the system can boot from the other disk. grub only installs the necessary files on one partition. However one can use a script as grub hook, and sync all partitions. This script needs to determine if a device is already mounted somewhere, or needs to be mounted. Turns out there is a little and not well-known tool for this.

Install Debian Bookworm on a Software RAID and EFI

Moving my systems away from Ubuntu, I also have to reinstall a server at home. This system has two equal disks for a RAID system, and my plan is to install Debian on it. Turns out, setting up a Software RAID on Debian and booting from EFI is not a straightforward approach. This blog posting describes the steps.

Understanding VACUUM, VACUUM template0, and Transaction ID Wraparound

PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage concurrent access to the database, and store each version of a tuple in a table. To keep the database efficient, PostgreSQL employs a cleanup process called VACUUM, which removes unnecessary tuples. This not only saves disk space and keeps the database size under control, it also prevents the dreaded 'Transaction ID Wraparound' issue. Regularly running VACUUM is crucial, including on the template0 database, which is normally handled by the Autovacuum daemon. However, sometimes manual intervention is necessary.

Obsidian Snap: version GLIBC_2.33 not found

Obsidian snap version was upgraded on my Ubuntu system - and stopped working. The whole promise of having a snap or containerized version of an app is to avoid dependency problems. That's a broken promise.

Blockquotes in Hugo

Hugo uses Markdown to create the content, which is then parsed into static HTML. One of the features of Markdown are quotes. Multiline quotes (block quotes) are possible, but they are not very intuitive.

Pythagorean theorem in ChatGPT - or how the AI invented the mathematical Missing Angle theorem

ChatGPT tried to calculate the angles and legs in a right angled triangle, and instead invented a new mathematical theorem of a Missing Angle

How to integrate YouTube videos into Hugo blog postings

This tutorial explains how to integrate YouTube videos into a blog posting in Hugo.

New Blog

New blog. Or, more exactly, new blog software. I moved this blog from Serendipity to Hugo.

Enable Deep Sleep mode on Tuxedo Computers Pulse 15 Gen2

A while ago we bought new Pulse 15 laptops from Tuxedo Computers. Installed Ubuntu on them, and for a while the sleep mode was nagging me, it does not really work. Today I found time to investigate this issue.

Obsidian: Paste URL into selection

I have a few community plugins enabled in my Obsidian. One of them is 'Paste URL into selection' - and it fits very well into the Markdown workflow. Also what you might know from other tools like Slack.