Database Administration & Monitoring

PostgreSQL on FreeBSD, getting started

Although we are running PostgreSQL mostly on Linux distributions, you can install an run PostgreSQL on a lot of other operating systems. On of them is FreeBSD. FreeBSD is one of those Unixes that derived from the(…)

SUSE Manager 4.1 – installation

What if you need absolute control over maintenance and package deployment or if you need to keep them up to date or if you need to automate the software management and the system provisioning with a high level of security,(…)

First steps on Kusto Query Language (KQL)

Do you know this query language?  No, it’s time to explain you and see what it is.   “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL(…)

Network configurations on ODA

Network configurations on ODA(…)

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

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.

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

PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived

By Mouhamadou Diaw Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will(…)