BE SHARING

Julia Gugel

PostgreSQL 13 and Patroni 2.0 – when parameters change

14.09.2020 by Julia Gugel

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

Database Administration & Monitoring

Patroni 2.0: New features – Patroni on pure Raft

11.09.2020 by Julia Gugel

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

Database Administration & Monitoring

How to create an AWS EC2 Auto Scaling Group

31.08.2020 by Julia Gugel

AWS comes with the great service of auto scaling, that gives the possibility to automatically adapt the environment to the changing needs. This helps to optimize costs and performance. With rising needs, your environment scales up and as soon as(…)

Database Administration & Monitoring

EDB PEM – Monitor your Postgres cluster

04.02.2020 by Julia Gugel

In my last post, I explained, how to setup a HA Postgres Cluster using EDB Postgres Advanced Server and Failover Manager. As a next step, we want to install the EDB Postgres Enterprise Manager to monitor what we setup before.

Database Administration & Monitoring

Setup a two node Postgres HA Cluster using EDB Advanced Server and EFM

03.02.2020 by Julia Gugel

Some time ago I had a customer looking for a two node PostgreSQL Master/Replica solution. As we need Oracle compatibility in a later step, we decided to go with the EnterpriseDB tools. This article should give you an introduction on(…)

Database Administration & Monitoring

One Host, multiple PostgreSQL Clusters – Monitoring using EDB PEM

24.12.2019 by Julia Gugel

At a customer we implemented the EDB Postgres Enterprise Manager. As they run multiple PostgreSQL cluster on one server, they wanted, for sure, to monitor all the cluster using PEM. This blog should give you a short guidance on(…)

Database Administration & Monitoring

Connection pooling with PgBouncer

07.11.2019 by Julia Gugel

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

Database Administration & Monitoring

How to scale up a Patroni cluster

06.11.2019 by Julia Gugel

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

Operating systems

SLES15 SP1 – New features

31.10.2019 by Julia Gugel

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

Database Administration & Monitoring

Patroni Operations – Changing Parameters

30.10.2019 by Julia Gugel

Sooner or later all of us have to change a parameter on the database. But how is this put into execution when using a Patroni cluster? Of course there are some specifics you have to consider. This post will give(…)