Database Administration & Monitoring, Database management, PostgreSQL TimescaleDB 15.02.2023 by Joël Cattin Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular)(…)
PostgreSQL Major PostgreSQL version upgrade in a Patroni cluster 22.06.2022 by Joël Cattin Introduction One of my customer recently asked me to upgrade its PostgreSQL instance from version 9.6 to version 14.3. The infrastructure is composed of 4 servers : – DB02-04 – Ubuntu 20.04 – supporting PostgreSQL, Patroni, HAProxy and etcd–(…)
Ansible, DevOps Managing Ansible with AWX – Part II – Organizations, Users and Teams 17.01.2022 by Joël Cattin In the 1st post of this serie, I demonstrate how easy it is to install AWX on a local Minikube Kubernetes cluster. Now that the installation is done and the access to the web console is(…)
Ansible, DevOps, Operating systems, Security Automating Linux patching with Ansible – How to keep all your environments consistent ? 14.01.2022 by Joël Cattin Your may want to patch your Linux servers on a regular basis (e.g using “yum/dnf update”). As always, it’s obviously recommended to : 1) Patch the TEST systems 2) Check if there is no side effects 3) Wait(…)
Database management, Hardware & Storage, Operating systems, Oracle When unreachable NFS share mess up your Dbvisit Standby configuration 09.12.2021 by Joël Cattin If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a(…)
Ansible, DevOps, Docker, Kubernetes Managing Ansible with AWX – Part I – Installation on Minikube 06.12.2021 by Joël Cattin AWX is a web based GUI tool for managing Ansible playbooks. It is the open source upstream project of Red Hat Automation Controller (formerly Ansible Tower) . As for Fedora and RHEL operating systems, the releases of(…)
Ansible, DevOps, Development & Performance Scanning Ansible code with Ansible Lint 27.09.2021 by Joël Cattin Introduction It’s always good to learn something new. But doing it the right way from the very beginning is even better. I recently started to work with Ansible and after creating a few roles, I quickly realized that there(…)
Ansible, DevOps, Operating systems, Security Automating Linux patching with Ansible 31.03.2021 by Joël Cattin Since the beginning of the year, several vulnerabilities have been discovered in the Linux Kernel as well as in others important and widely-used packages. Among them, there was the famous CVE-2021-3156 affecting the sudo package and allowing(…)
AWS, Cloud AWS EC2 instance deployment with Terraform 03.02.2021 by Joël Cattin 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.
Database Administration & Monitoring, Database management, PostgreSQL pgBackRest – a simple privileges-related issue 29.05.2020 by Joël Cattin I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some(…)