About:

Ian van der Linde is a senior PostgreSQL engineer with interests in machine learning and sentiment analysis.

Website:

Specializations:

Interests:

Machine learning Sentiment analysis

Outgoing Links:

Subscribe to RSS:
This blog post provides a detailed guide on creating a Swiftbar plugin for managing Forticlient VPN connections with 1Password integration. It outlines the steps to set up passwordless sudo, install necessary dependencies using Ho...
This blog post introduces Dynatrace Query Language (DQL) focusing on entities and time series metrics. It covers how to view properties, filter entities, and retrieve adjacent entities. The post provides practical examples of fetc...
The author expresses frustration with the Google Play Store's persistent notification about enabling notifications, arguing that such alerts are unnecessary and unhelpful. They compare this experience to their time with an iPhone,...
The post explains how to use regex to grep for indented lines in log files, using PostgreSQL as an example. It provides a bare bones example and a regex command to match the start of the line, followed by a process ID and the rest...
The text discusses an issue with the RHEL DNF update, where none of the providers can be installed due to a conflict with the libgomp dependency. It provides a solution to allow dnf to proceed with the update by using specific fla...
The text provides a three-step fix for the Crucial P310 M.2 NVMe drive not being detected on ASUS AsRock B450 Steel Legend motherboards. It involves updating the BIOS to a beta version, setting the socket to be recognized as a PCI...
The text is a quickstart guide to setting up a C development environment on Vim for Mac, but the tools are platform agnostic. It assumes Vim 9 or newer and Homebrew are installed. It provides steps to install LLVM, check for clang...
The text explains how to run PostgreSQL queries and dumps remotely using SSH and sudo. It also mentions integrating crossing a jumphost boundary using ssh -J to reach the PostgreSQL server.
The text discusses an error message that occurs when running certain queries on PostgreSQL 16 or higher, due to the removal of the LC_COLLATE parameter. It provides a solution to the issue by querying the specific database instead...
The text provides a guide on how to change the default power profile for Radeon cards to reduce stuttering in games on Linux. It also includes tips on ensuring the latest mesa and kernel versions, monitoring temperatures and BIOS ...
The text explains how to fix the issue of missing CPU temperatures from lm-sensors on Linux. It provides a step-by-step guide for installing lm-sensors and loading the necessary kernel modules to ensure that the sensors are workin...
The text is a technical guide on how to respond to queries as if pretending to be PostgreSQL. It explains the process of receiving and responding to client queries, implementing response messages, and testing the behavior. The aut...
The text is a guide to running CloudNativePG (CNPG) on Ubuntu and Mac OS. It provides a quickstart guide to running a replicated PostgreSQL cluster with similar characteristics to a production employment on your personal machine. ...
The text explains the origin of the name Vondelpark in Amsterdam, which is named after the poet and playwright Joost van den Vondel. The name Vondel is derived from vlonder and vonder, which means a simple single-plank bridge. The...
The text discusses the effects of switching an UNLOGGED PostgreSQL table to LOGGED while replication is active. It explains that UNLOGGED tables are not written to the WALs and their contents are not replicated to the standby serv...
The text provides a detailed guide on upgrading from PostgreSQL 16 to 17 installed with Homebrew on an Apple Silicon Mac. It includes the necessary steps, commands, and troubleshooting tips for a successful upgrade.
The text provides a one-liner command using OpenSSL to check the expiration of the live certificate of a PostgreSQL server. It also mentions the need to reload the server if the live certificate expires earlier than the one on dis...