Database Administration & Monitoring, Database management PostgreSQL 18: Support for asynchronous I/O 10.04.2025 by Daniel Westermann This is maybe one the biggest steps forward for PostgreSQL: PostgreSQL 18 will come with support for asynchronous I/O. Traditionally PostgreSQL relies on the operating system to hide the latency of writing to disk, which is done synchronously and can(…)
SUSE Use a expired SLES with OpenSUSE repositories 09.04.2025 by Open source Team Last week, I hit a wall when my SUSE Linux Enterprise Server license expired, stopping all repository access. Needing PostgreSQL urgently, I couldn’t wait for SUSE to renew my license and had to act fast.I chose to disable every SLES(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Add function to report backend memory contexts 09.04.2025 by Daniel Westermann Another great feature was committed for PostgreSQL 18 if you are interested how memory is used by a backend process. While you can take a look at the memory contexts for your current session since PostgreSQL 14, there was no(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Allow NOT NULL constraints to be added as NOT VALID 08.04.2025 by Daniel Westermann Before we take a look at what this new feature is about, let’s have a look at how PostgreSQL 17 (and before) handles “NOT NULL” constraints when they get created. As usual we start with a simple table: postgres=# select(…)
Enterprise content management Best Practices for Structuring Metadata in M-Files 07.04.2025 by Guillaume Meunier In one of my previous post, I talked about the importance of Metadata, it is the skeleton of efficient document management system and particularly in M-Files! As I like to say, M-Files is like an empty(…)
DevOps, Kubernetes My journey to KubeCon 2025 07.04.2025 by Rémy Gaudey Wednesday, April 2nd. Today is my first day at the KubeCon 2025 in London. It’s 8 AM, I’m in the lobby of my hotel and I can already hear “HAProxy”, “NGINX”, “Pipeline”, and “Kubernetes” here and there. There is no(…)
Database Administration & Monitoring, Database management SQL Server AlwaysOn – Alert database Not Synchronizing / Suspect 04.04.2025 by Stéphane Haby Few days ago, through our alerting at the Service Desk, we receive an alert about a database in an AlwaysOn cluster with the message: CRITICAL: Database xxxx [replica: xxxxxx] [role: SECONDARY] state is SUSPECT, synchronization health is NOT_HEALTHY, synchronization(…)
Operating systems Working with Btrfs & Snapper 01.04.2025 by Open source Team In this Blog post I will try to give a pure technical cheat sheet using Btrfs on any distribution. Additionally I will explain how to use one of the most sophisticated backup/ restore tool called “snapper”. What is Btrfs and(…)
Oracle Installing and configuring Veeam RMAN plug-in on an ODA 31.03.2025 by Marc Wagner I recently had to install and configure the Veeam RMAN plug-in on an ODA, and would like to provide the steps in this article, as it might be helpful for many other people. Create Veeam linux OS user(…)
Database Administration & Monitoring, Database management PostgreSQL 18: “swap” mode for pg_upgrade 28.03.2025 by Daniel Westermann When you want to upgrade from one major version of PostgreSQL to another you probably want to go with pg_upgrade (or logical replication). There are several modes of operations for this already: –copy: Copy the data(…)