How to Manage PostgreSQL Clusters with GitOps using CloudNativePG and ArgoCD
At PGConf.de in Berlin this year, I had the pleasure of presenting on the powerful combination of CloudNativePG and GitOps. For those who couldn't attend — or anyone looking to streamline their PostgreSQL cluster management — this blog post shows how to apply GitOps principles with CloudNativePG for a more efficient and reliable database [...]
Reflections on PGConf.DE 2025 – A Community Stronger Than Ever
Last week, we had the pleasure of attending PGConf.DE 2025 in Berlin as a Platinum Sponsor – and what a conference it was! As always, the German PostgreSQL community came together with energy, expertise, and enthusiasm. This year's event was particularly special, as it marked a significant milestone in the growth and maturity of [...]
Tutorial: Database load testing using HammerDB
HammerDB is an open source database benchmarking software that supports PostgreSQL, Microsoft SQL Server, IBM Db2, Oracle, MariaDB, and MySQL, as well as CLI, local GUI, and a web browser GUI. The benchmarks used by HammerDB, TPROC-C and TPROC-H, are based on the widely used TPC-C- and TPC-H benchmarks. Test results are reported in [...]
Auditing in PostgreSQL (Part 2)
Building on the first blog entry in the series, Auditing in PostgreSQL, it is time to extend the audit features used. This blog entry introduces the extension pgauditlogtofile, which separates the audit log trail from the default PostgreSQL log into a dedicated file. It is common practice in many companies to separate the audit [...]
Auditing in PostgreSQL (Part 1)
Many financial and insurance enterprises are required to comply with regulatory mandates such as the GDPR. These regulations often include auditing database access to track all activities, whether by specific individuals, such as DBAs, or general data access and manipulation. This blog series, consisting of three articles, will explore auditing in PostgreSQL. The first [...]
Ensuring High Availability with Patroni: Handling Failover
Nowadays, high availability and data integrity are the most important things in the database world. Downtime and data loss can be very expensive for any company. One way to avoid this is by having a failover mechanism. Failover is a mechanism that allows a system to continue operating, possibly at a reduced level, rather [...]