A streaming replica on PostgreSQL 14.23 stops replaying WAL coming from a primary on 14.17. The startup process self-deadlocks acquiring MultiXactOffsetSLRULock inside RecordNewMultiXact → SimpleLruWriteAll. The bug is in the back-patched compatibility code introduced by commit 789d65364c (“Set next multixid’s offset when creating a new multixid”) and partially addressed by c60a58204435 in 14.22. This post documents the symptoms, diagnosis, and a workaround.
How to convert Claude chats to LMStudio format for local continuation
Python script to convert your Anthropic/Claude data export to a popular local LLM engine
How to script RouterOS to failover primary WAN in a Mikrotik router
Keeping your network online when your primary WAN goes offline
How to install NVIDIA drivers and specific CUDA versions on Ubuntu 22.04 Server (not Docker)
After installing Ubuntu 22.04 server for AI research purposes using Nvidia GPU(s), the first thing you must do is get your GPU working.
How to identify tables in TimescaleDB that aren't optimized for performance
Use this simple SQL query to quickly identify tables in TimescaleDB that aren't using features like retention policies, automatic moving, and high-performance chunking to their full potential.