All articles

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

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

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

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

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

PRGH-1030 when doing restore-node -g on ODA

Introduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something(…)

pgvector, a guide for DBA – Part3 AI agent and workflows

Introduction Nowadays, everyone in IT is well versed in using ChatGPT and other LLM-powered Chat to retrieve information like Google or try to learn something with it. The problem with those models is their accuracy. Current AI models only know(…)

PostgreSQL 18: More granular log_connections

Many of our customers enable log_connections because of auditing requirements. This is a simple boolean which is either turned on or off. Once this is enabled and active every new connection to a PostgreSQL database is(…)

Why Metadata Matters?

In today’s digital landscape, efficient Content Management is crucial for business productivity. While many organizations still rely on traditional folder-based file management. Modern solutions like M-Files offer a smarter way to store, organize, and retrieve information. The key differentiator?(…)

pgvector, a guide for DBA – Part2 indexes

Introduction In the last blog post we did setup a LAB with a DVDRental database mixed with Netflix data on top which we created some embeddings hosted on the same tables thanks to pgvector. In this second part, we(…)