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 [...]
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 [...]
Get Notified: Setting Up Alerts in Grafana
If you are using Grafana to monitor your systems, you are already ahead of the game. But did you know that you can also use Grafana to set up alerts? This is a great way to get notified when something goes wrong with your systems. In this blog post, we will show you how to [...]