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(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Add “–missing-stats-only” to vacuumdb 20.03.2025 by Daniel Westermann 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. A(…)
Enterprise content management Do you know Aino? 20.03.2025 by Guillaume Meunier 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 Aino leverages(…)