All articles

Zabbix Configuration with API

Despite the will of Zabbix to be as automated as possible, some tasks cannot be automated. Nevertheless, Zabbix offers an HTTP-based API which can be used programmatically. This opens the door to huge possibilities in terms of automation.

Guide to Install and Use pgFormatter on Linux (openSUSE)

pgFormatter is a command-line tool used to format SQL code for PostgreSQL databases. It helps improve code readability and maintainability by applying consistent indentation and formatting rules to your SQL queries. This guide will walk you through the process(…)

Unable to start WebLogic Admin Server during host reconfiguration

In my previous blog named “Changing Fusion Middleware repository database“, I explained how to move a Fusion Middleware repository database from one host to a new host. During the run of this exercise, I came over an issue(…)

Apache Kafka Consumer Group

On producer side, messages are load balanced across partition based on hashed key. On the consumer side, to ensure that each message is processed by only one consumer within the group, allowing for load balancing, fault tolerance, and efficient(…)

PostgreSQL 17: pg_wait_events

As development of PostgreSQL 17 already started there are already some commits which bring in new functionality. One of them introduces a new catalog view called “pg_wait_events”. As the same implies, this view lists the known wait events for(…)

PostgreSQL 16: Playing with pg_stat_io (2) – evictions

In the last post in this little series we’ve looked at the “extends” statistic in pg_stat_io. In this post we’ll look at the “eviction” statistic. Before we go into the details:(…)

Apache Kafka Concepts by Example

In this blog post, I will demonstrate the first few concepts to understand when you want to learn Apache Kafka. Documentation explains it well, but I find that concrete examples give a better feeling of(…)

Connect a Kubernetes cluster to GitLab

To interact with a Kubernetes cluster during builds, deployments or other tasks in GitLab CI/CD, you need to install the GitLab agent on the cluster. This operation is very easy with GitLab ! The official documentation is(…)

Redis: Using Access Control List (ACL) part2

Introduction In the first part with have seen what are Redis ACL and why we are using it.WE also have seen how to list users with the ACL LIST command. Let’s continue and go deeper with command usage(…)

Simplifying PostgreSQL Management: A Guide to Install and Use pgcli

Managing databases is a crucial aspect for a DBA, and PostgreSQL is a powerful open-source relational database management system that is widely used. To interact with a PostgreSQL database, DBA and developers often rely on command-line tools. The default(…)