Setting up a highly available PostgreSQL Cluster with Patroni using Spilo Image
Patroni Cluster In the world of modern data-driven applications, having a reliable and available database is a must. This is where Patroni and Spilo come into play. Patroni is an open-source solution for managing high-availability PostgreSQL clusters, and Spilo is a container image that combines PostgreSQL and Patroni, simplifying the deployment of fault-tolerant [...]
Building a High-Availibity etcd Cluster on AWS
Welcome to the journey of building a high-availibity distributed key-value store. In this project we will build an etcd cluster inside Podman containers on AWS EC2 Instances. etcd is an open source, distributed key-value store designed for securely managing configuration data in distributed systems. Using Raft consensus protocol, it ensures consistent data across multiple [...]
Provisioning AWS Resources with Ansible
In this section, we will learn how to provision AWS resources locally. We will use the Ansible AWS Collection to provision the AWS resources. We will create the following AWS resources: VPC Subnet Internet Gateway Route Table Security Group EC2 Key Pair EC2 Instance Prerequisites [...]
How to Create an etcd Container Image with Buildah and RedHat’s UBI
Containers are an inherent part of today's work for developers and operators. They offer an elegant way of providing needed applications started up at the blink of an eye or running at scale in the cloud or a data center. This how to will display one of several options to create such [...]
PostgreSQL Conference Europe 2022
My impressions of the PostgreSQL Conference Europe 2022 in Berlin. Finally, after a forced break of two years, PostgreSQL Conference Europe took place again from October, 25th to 28th in Berlin, Germany. The conference was organized in the Marriott Berlin hotel, a few meters away from Brandenburger Tor. A total number of 604 [...]
Development VM for edb-ansible Collection
A customer recently required assistance in automating their PostgreSQL installation with Ansible. EDB's edb-ansible collection provides all the required functionality and was used by me to provide the required playbooks. First, I had to deal with one problem: my notebook runs Windows 10. So, I decided to take care of it with a small [...]