Patroni

Setting Up Prometheus and Grafana for a Patroni cluster

In today’s data-driven world, monitoring and visualizing the health and performance of your database clusters is a must. With tools like Prometheus and Grafana, you can gain valuable insights into your PostgreSQL Patroni setup, ensuring its smooth operation and proactive(…)

How to Fix the etcd Error: “etcdserver: mvcc: database space exceeded” in a Patroni cluster

If you’re encountering the etcd error “etcdserver: mvcc: database space exceeded,” it means your etcd database has exceeded its storage limit. This can occur due to a variety of reasons, such as a large number of revisions or excessive data(…)

Upgrade etcd in a patroni cluster

In a distributed database system like PostgreSQL managed by Patroni, etcd plays a critical role as the distributed key-value store for cluster coordination and configuration. As your system evolves, upgrading etcd becomes necessary to leverage new features, bug fixes, and(…)

Troubleshooting Patroni Cluster: pg_hba Configuration not applied

In the world of database management, high availability and data integrity are of most importance. Patroni, a robust open-source solution, offers a way to manage and maintain PostgreSQL high availability clusters seamlessly. However, even with tools like Patroni, you can(…)

Bootstrap Patroni Cluster from pgBackRest Backup

While preparing myself for the pgconf.eu in Berlin this week I made a lot of research regarding Patroni and pgBackRest. I was aware that it’s possible to recreate a replica from a pgBackRest backup. But I was also wondering, what(…)

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

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.

Minor PostgreSQL version upgrades in a Patroni cluster

Last week PostgreSQL 14.1, and all other minor versions for the supported version of PostgreSQL have been released. As usual, it is highly recommended to update to the latest minor release as soon as possible. Minor version(…)

Patroni on FreeBSD 13?

You can already find several blog posts around PostgreSQL protected by Patroni on our blog. They all have in common, that the setup is on a flavor of Linux. As I got impressed by(…)

PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived

By Mouhamadou Diaw Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will(…)