Backing up & Restoring a Highly Available PostgreSQL Cluster with S3
In our previous blog posts, Setting up a highly available PostgreSQL Cluster with Patroni using Spilo Image, we embarked on a journey to set up a highly available PostgreSQL cluster managed by Patroni using the Spilo image. We saw how Patroni, in collaboration with an etcd cluster, elevates PostgreSQL to new heights of availability [...]
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 [...]
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 [...]
Bereitstellung von AWS-Ressourcen mit Ansible
In diesem Abschnitt werden wir lernen, wie man AWS-Ressourcen lokal bereitstellt. Wir werden die Ansible AWS Collection verwenden, um die AWS-Ressourcen bereitzustellen. Wir werden die folgenden AWS-Ressourcen erstellen: VPC Subnet Internet Gateway Route Table Security Group EC2 Key Pair EC2 Instance Voraussetzungen Um AWS-Ressourcen bereitzustellen, benötigen [...]
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 [...]