All articles

8000 databases in one PostgreSQL cluster?

A while ago I posted this tweet on Twitter: #Postgresql friends: 8000 databases. One cluster, 8000 clusters, Kubernetes,, what would be your choice? Let's assume 10gb per database. I know backup/restore, inodes etc, no discussions about(…)

Oracle 21c : Two nodes Grid Infrastructure Installation

By Mouhamadou Diaw Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below(…)

An introduction into server side programming in PostgreSQL – 3 – PL/pgSQL, procedures

In the first to posts in this series (An introduction into server side programming in PostgreSQL – 1 – SQL functions, basics , An introduction into server side programming in PostgreSQL – 2 –(…)

JENKINS – Add a new node ( slave ) to your Windows Jenkins master

Hi, As you already know Jenkins architecture is based on master slave architecture.This is useful and best practice to add slave/nodes to Jenkins master for many purposes such as security (avoid malicious code on the master for example and(…)

SQL Server tips: How to migrate database-users in another domain without touching permissions

By a customer, I must migrate a database from a domain to another. The goal is to keep the database-user permissions, take the new SID from the windows login of the new domain and change the database-user name.

Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts

In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps(…)

Documentum – RCS/CFS Upgrade in silent fails with IndexOutOfBoundsException

Several years ago, I wrote a series of blogs regarding the silent installation of Documentum Components, including for a RCS/CFS (HA part of a Repository). In there, I described the process and gave an(…)

Documentum – IDS on Windows Server not able to start with error 31: device not functioning

Documentum Interactive Delivery Services or IDS is a Documentum product that can be useful to publish some documents to an external web server or something similar. It usually works rather well, even if there hasn’t been much changes in the(…)

An introduction into server side programming in PostgreSQL – 2 – SQL functions, sets, udts and polymorphic types

This is part two of the little series about server side programming in PostgreSQL. In the last post we had a look at the basics when it comes to SQL functions. We learned how to write those(…)

AWS EC2 instance deployment with Terraform

When it comes to quickly provision a server in the Cloud, using an Infrastructure as Code (IaC) tool is a solution to consider. There are many IaC products available and among them, Terraform seems to be the most popular.