All articles

Zabbix Better Storage

Among the different possibilities for Zabbix storage, one piqued my curiosity: TimescaleDB TimescaleDB is a time series database plugin for PostgreSQL. Joël Cattin already blogged about it here from a(…)

JBoss EAP 7 – Use vault to protect passwords

JBoss EAP simplifies a lot of server configuration by consolidating all subsystem configurations into a single XML file (standalone.xml or domain.xml). This, however, can expose sensitive information to any user that has access to the configuration files. For example, datasource(…)

PostgreSQL 17: Allow “\watch” to stop based on the number of rows returned

psql already is really powerful but still it gets more features with almost every release of PostgreSQL. One example is the “\watch” meta command. This command was introduced in PostgreSQL 9.3 and hasn’t changed much(…)

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