All articles

Building PostgreSQL with Meson

Last year, around this time, there started a thread on hackers which was about building PostgreSQL with meson. I didn’t know anything about Meson at this time, and don’t know much more(…)

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered that a very(…)

Oracle CloudWorld 2022 – Day 1 : Arriving in Las Vegas

What a chance for me to be able to participate to this great event! First of all I would like to thank dbi management to have given me the chance to go there and to participate to it. Las Vegas(…)

Kubernetes: MetalLB in-depth

By working on a project for one of our customer, I have investigated how MetalLB works in details. This Kubernetes cluster is on-premises only and uses Nginx Ingress Controller for processing incoming L7 and L4 traffic. If you(…)

NFS mount using Redhat autofs

First of all, why would you use autofs over nfs mount in the fstab ? Shares are accessed automatically and transparently when a user tries to access files or directories under the designated mount point of the remote filesystem to(…)

PostgreSQL from packages on NetBSD

The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and(…)

Tips to Develop a new Component on top of YaK Core

If you are following social medias, you are probably aware of the new product that dbi services launched which is called YaK (news here). With Pascal Brand, we(…)

Add On-Premises Host in YaK Core

Even if YaK Core does not manage on-premises servers provisioning, these can be easily added to YaK inventory. If you are too excited, can’t wait to test YaK and have no cloud account handy, you can(…)

PostgreSQL from source on OpenBSD

In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of(…)

PostgreSQL from packages on OpenBSD

Almost all of our customers run PostgreSQL on one of the distributions of Linux, either installed from packages or from source code. But there is not only Linux, there a various flavors of BSD you can(…)