Infrastructure at your Service

All Posts By

Julia Gugel

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 | No Comments

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 | No 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
Julia Gugel

Connection pooling with PgBouncer

By | Database Administration & Monitoring | No Comments

Some of you may know the case: As soon as the number of users grow, the number of resource problems increases. Have you ever thought about using a connection pooler? Too complex, too much administration effort? In this post I like to explain, how the connection pooler can help you with your memory, as well as showing you the simplicity of setup connection pooling with PgBouncer.

Read More
Julia Gugel

How to scale up a Patroni cluster

By | Database Administration & Monitoring | No Comments

During the preparation of my presentation for the pgconf.eu I ran into one big issue. I had to stop my cluster to add a new node. That was not the way I wanted to archive this. I want a high availability solution, that can be scaled up without any outage. Due to a little hint during the pgconf.eu I was able to find a solution. In this post I will show the manually scale up,…

Read More
Julia Gugel

SLES15 SP1 – New features

By | Operation systems | No Comments

With SLES15 SUSE introduced the Multimodal OS and the unified installer. Means, you only get what you really need. Your OS is flexible and you can easily add features you need and remove them as well. But this article shouldn’t be an explanation of the multimodal OS, it will show you some of the new features of SLES15 SP1.

Read More