All articles

PostgreSQL 18: Allow NOT NULL constraints to be added as NOT VALID

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=#(…)

Best Practices for Structuring Metadata in M-Files

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(…)

My journey to KubeCon 2025

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(…)

SQL Server AlwaysOn – Alert database Not Synchronizing / Suspect

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,(…)

Working with Btrfs & Snapper

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(…)

Installing and configuring Veeam RMAN plug-in on an ODA

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(…)

PostgreSQL 18: “swap” mode for pg_upgrade

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(…)

PostgreSQL 18: Add “–missing-stats-only” to vacuumdb

Loosing all the object statistics after a major version upgrade of PostgreSQL with pg_upgrade is one of the real paint points in PostgreSQL. Collecting/generating the statistics can take much longer than the actual upgrade which is quite painful.

Do you know Aino?

Nowadays, working in a company requires handling of huge amounts of information, and therefore efficiency is crucial!M-Files Aino, your virtual assistant integrated in M-Files, is here to support you in your daily activities. What is M-Files Aino? M-Files(…)

What is the most secure way to call an external job from an Oracle (pluggable) database?

I recently asked myself this question after having been confronted with a quite challenging situation, which will be been dissected in this post. Indeed, most of the DBA are aware about several mechanism offered by the Oracle database engine(…)