All articles

Zabbix Report Scheduler Setup and Troubleshooting

I wanted to test the Zabbix report scheduler. In this blog, I will explain how to do it as well as the different issues I faced (with cause and resolution, obviously 🙂 ). By the way, report scheduler(…)

“create user”, “create role”, what should be used in PostgreSQL?

Recently we’ve seen a video on YouTube which recommends not to use the “create user” command in PostgreSQL and instead always use the “create role” command. It was also mentioned that “create group” should not be used as well.

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