All articles

Why is the default postgres database slightly larger than template1?

You probably know that a fresh initialized PostgreSQL cluster comes with three databases by default: template0, template1, and postgres. If you want to know why they are there, and what their purpose is, check this post. In(…)

PostgreSQL on AWS Graviton2: CFLAGS

By Franck Pachot . In a previous post I’ve compiled PostgreSQL with GCC 7 and GCC 11 with the default options and checked that the ARM v8.2 features were used. However it may not be so simple:(…)

PostgreSQL, pg_ctl and signals

I believe most people use pg_ctl nowadays to start, stop, or restart a PostgreSQL instance. You can do all these tasks without using pg_ctl, but you'll notice in a minute that pg_ctl really is your friend. Even(…)

Does it still make sense to deploy a virtualized HA ODA in 2021?

Introduction Starting from version 19.11 of the Oracle Database Appliance software bundle, OLVM will definitely replace OVM server as virtualization engine. This change has quite a big impact as there will be no more virtualized specific deployment. Bare metal will(…)

El Carro: The Oracle Operator for Kubernetes

By Franck Pachot . Google Cloud, Open Source and Oracle Databases… what seems to be a paradox is possible, thanks to cloud providers who contribute to open infrastructure. The idea is to use Operators (custom resource controllers on Kubernetes)(…)

JENKINS add and configure Slack notifications

Hi team, If you wonder how to improve your team work efficiently during your Jenkins projects here is a good solution: configure slack notifications,what is slack notification?how can we configure for our Jenkins builds? Below we will see(…)

Starting with Simple Ansible Playbooks

Creating simple ansible playbooks(…)

Getting started with Citus – Setting up a four node cluster

One issue with traditional database systems like PostgreSQL is, that you cannot easily scale vertically. Of course you could add read replicas and offload read operations, but that either requires changes in the application, or putting something in front that(…)

Virtual Symposium SQL Server & Azure SQL – Session: Debugging without debugger

As a consultant at dbi services we can dedicate a significant part of our time to training and I took the opportunity today to attend an online conference. In this blog post, I will present this event and(…)

CentOS 8 binary compatible alternatives

There is a lot of roumors around since it was anounced to switch CentOS 8 from a Downstream Build from RHEL 8 to a Upstream Build for RHEL 8 on December 8th 2020. Many people asked why a second(…)