PostgreSQL

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Fast setup of a two node repmgr cluster with auto failover

This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the(…)

Recreate a Patroni replica using pgBackRest

In my last blog we had a look on how to bootstrap a complete Patroni Cluster from pgBackRest. But there is also the possibility to recreate only one Patroni node using pgBackRest. In this blog we(…)

pgconf.eu 2022: Review

Last week I had the pleasure to join the pgconf.eu in Berlin. After three years of waiting since Milan 2019, I was really excited to travel to Berlin to meet all the PostgresFriends again and of(…)

2022.pgconf.eu Berlin conference for tech

Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started(…)

Setup a PostgreSQL Instance in Google Cloud SQL

This blog will be the first of a series of blogs, to report about my experiences with Google Cloud SQL. In this blog we will setup a basic PostgreSQL instance in the Google Cloud. If you’re new to Google Cloud,(…)

PostgreSQL Cluster using repmgr

With this blog I describe the installation of a PostgreSQL Cluster using repmgr instead of Patroni. Repmgr was originally developed by 2ndQuadrant which is now part of EDB and EDB decided for the 2ndQuadrant tools for the future, barman as(…)

PostgreSQL on 80 core ARM Server

This Blog is about intallation and testing PostgreSQL 14 latest on an ARM based 80 core Server using Rocky Linux 8.6. Many thanks to Happyware for providing the machine used for this Blog. https://happyware.com/ The machine used for this(…)

Major PostgreSQL version upgrade in a Patroni cluster

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–(…)

Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL

One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source(…)