Open source Team

How to upgrade Patroni

It's been a while since I wrote the blog post about PostgreSQL 13 and Patroni 2.0. On this blog I received a comment, if it's possible to explain, how to upgrade from Patroni 1.6 to 2.

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 2

Within the first part I have described the setup of Consul as replacement for ETCD. Here now the setup ob keepalived, haproxy and patroni. The needed packages I have installed within the first part, so let’s start with the(…)

PostgreSQL 15: Some new features

PostgreSQL version 15 is on its way and we get a better and better look, what will be included in the future release. So it's time to have a look at some new future features(…)

Upcoming RHEL 9

This Blog is about a setup of RHEL 9 BETA and changes to RHEL 8 and Fedora 34 which is the base of RHEL 9. Let’s start with the setup. Start the installation. Preview warning:(…)

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 1

This blog describes the setup of a Consul Cluster on RHEL 8 and clones, it will be the base for a Patroni HA setup using RPM Packages from postgresql.org. Many Patroni setups are using ETCD, but ETCD is not(…)

Migration from CentOS 8 to Rocky Linux 8

This Blog describes the Migration from CentOS 8 to Rocky Linux 8. And hopefully there is a backup or VM Snapshot in place when something goes wrong. At first Updating CentOS 8 to the latest is required, but this(…)

Migrating from CentOS 8 to AlmaLinux 8

In our blogs we already talked about Migrating a CentOS 7 EC2 instance to Rocky Linux 8 and CentOS 8 machine to Red Hat 8 , but how does it look(…)

Updating Password in PostgreSQL from md5 to scram-sha-256

Many installations have a history of many major PostgreSQL releases. With PostgreSQL 10 comes scram-sha-256 for hashing passwords, by installing from packages scram-sha-256 is the default setting for new installations since PostgreSQL 13. With this small blog I will(…)

PostgreSQL on ARM using Odroid N2/N2+

For this installation i’m using a Hardkernel Odroid N2/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on(…)

PostgreSQL Flexible Server on Azure, Status

This Blog is about the actual status of the development on Microsoft’s side for the Azure Flexible Server for PostgreSQL. The Flexible Server is announced “GA Ready” at November 30st, after shiftig the GA Raeady date several times. But(…)