BE SHARING

Search results for patroni

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

04.03.2022 by Karsten Lenz

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

Database Administration & Monitoring

Open source monitoring solutions (2) – Zabbix agents and PostgreSQL monitoring

03.12.2021 by Daniel Westermann

By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it's back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself(…)

Database Administration & Monitoring

Open source monitoring solutions (1) – Zabbix server setup

29.11.2021 by Daniel Westermann

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious(…)

Database Administration & Monitoring

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

16.11.2021 by Daniel Westermann

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a(…)

Database Administration & Monitoring

Getting started with the Zalando Operator for PostgreSQL

13.03.2021 by Daniel Westermann

In the previous posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes, Rancher, up and running, on(…)

Database Administration & Monitoring

Easy failover and switchover with pg_auto_failover

10.12.2020 by Daniel Westermann

One the really cool things with PostgreSQL is, that you have plenty of choices when it comes to tooling. For high availability we usually go with Patroni, but there is also pg_auto_failover(…)

Database Administration & Monitoring

What is EDB?

01.11.2020 by Open source Team

Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if(…)

Database Administration & Monitoring

Azure Database for PostgreSQL

25.09.2020 by Karsten Lenz

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where(…)

PostgreSQL

pgconf.eu – Welcome to the community

18.10.2019 by Gérard Wisson

On tuesday I started my journey to Milan to attend my first pgconf.eu, which was also my first big conference. I was really excited what will come up to me. How will it be, to become a visible part of(…)

Database Administration & Monitoring

Where can you find core developers asking people what is missing in PostgreSQL? pgconf.eu.2019

17.10.2019 by Daniel Westermann

One of the major advantages of PostgreSQL conferences when you compare it to other conferences is, that you can listen to talks where the actual developers are presenting their work. You have questions about a feature, you want to know(…)