Infrastructure at your Service

All Posts By

Julia Gugel

Julia Gugel

Running two Patroni on one host using an existing etcd

By | Database Administration & Monitoring | No Comments

Have you ever asked yourself, how to create a second Patroni PostgreSQL cluster on an existing server using the existing etcd? My first idea was to study the documentation of Patroni, but unfortunately without big success. This post should help to identify the changes you have to do on the hosts to run two parallel Patroni clusters using an existing etcd.

Read More
Julia Gugel

Installing EDB Advanced Server without EDB Repository

By | Database Administration & Monitoring | No Comments

Almost all of us, who already installed Enterprise DB Tools on a Linux server know the procedure. You need to add the EDB Repository to your server or your Red Hat Satellite configuration and after that you can easily install the tools you need. But what happens, if you are not able to add the repository? The answer is really simple: Download the rpms and install them directly on the server.

Read More
Julia Gugel

PostgreSQL 13 and Patroni 2.0 – when parameters change

By | Database Administration & Monitoring | One Comment

Starting with PostgreSQL 13 there is a name and value change of one of the parameters used for the streaming replication of a replica server. Some may already know which parameter I am talking about. Until Postgres 12 it was called “wal_keep_segments” but with PostgreSQL 13 it will become “wal_keep_size”. In this small post I will explain, what changed and which nice new feature Patroni 2.0 offers us to not get in trouble using old…

Read More
Julia Gugel

Patroni 2.0: New features – Patroni on pure Raft

By | Database Administration & Monitoring | 3 Comments

Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It’s possible to run Patroni without 3rd party dependencies. So no Etcd, Consul or Zookeeper is needed anymore. Great improvement! In this blog we will have a look at the setup and try an failover as well.

Read More