All articles

NFS Storage Configuration for Kubernetes

For one of our important customers, we are working on a major project to migrate critical applications to containers. From the implementation of the Kubernetes architecture to the deployment of applications and the administration of the platform, we are responsible(…)

Fun with arrays in PostgreSQL

As you might already know, PostgreSQL comes with many, many data types. What you might not know is, that you can create arrays over all this data types quite easily. Is that(…)

A day of conferences with the Swiss Oracle User Group

Introduction I’m not that excited with all these events arround Oracle technologies (and beyond) but it’s always a good place to learn new things, and maybe the most important, discover new ways of thinking. And regarding this point, I was(…)

PostgreSQL 12 : Setting Up Streaming Replication

By Mouhamadou Diaw PostgreSQL 12 was released a few month ago. When actually setting up a replication, there is no longer recovery.conf file in the PGDATA. Indeed all parameters of the recovery.conf should be now in the postgresql.conf file. And(…)

Elapsed time of Oracle Parallel Executions are not shown correctly in AWR

As the elapsed time (time it takes for a task from start to end, often called wall-clock time) per execution of parallel queries are not shown correctly in AWR-reports, I thought I setup a testcase to find a way to(…)

Dealing with corrupted system indexes in PostgreSQL

This is something you do not want to see on an important PostgreSQL system: postgres@centos8pg:/home/postgres/ [pgdev] psql psql: error: could not connect to server: FATAL: index "pg_class_oid_index" contains unexpected zero page at block 0 HINT: Please REINDEX it. The hint(…)

Some words about SOUG Day in Lausanne

Today I participate to SOUG Day which takes place in Lausanne at the "Centre Pluriculturel et social d’Ouchy".

Can there be orphaned data files in PostgreSQL?

PostgreSQL, as all other relational database systems, needs to persist data on disk, either by writing the writing the write ahead log or by synchronization the data files on disk whenever there is a checkpoint. When(…)

PostgreSQL 13 will allow to drop databases even when there are connections

One of the most popular blogs I've written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). One of the(…)

Galera Cluster 4 with MariaDB 10.4.8: part 2

My previous blog was about the MariaDB Galera cluster new features (version 10.4). Now I will only focus on the streaming replication and give you an overview of all the tests I performed. How(…)