All articles

DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up

One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication(…)

Oracle Database Appliance (ODA): Some listeners do not start anymore when booting

A colleague of mine had the issue some time ago and I recently experienced the same behaviour at a customer’s ODA: A couple of Listeners did not start when booting. Starting them as user grid with srvctl start listener -listener(…)

Redis:Connect a Redis plugin to Grafana

Introduction: Monitoring our Redis database is one of the first thing we want to do : Checking the database status , the queries consumption and also make a report on it. For that, we will use Grafana: It is an(…)

Hyland Summit 2023 – Düsseldorf

Introduction The event took place in a very pleasant street, the Königsallee, also known as the Kö, is a shopping street in Düsseldorf and considered to be the most beautiful avenue in Düsseldorf. Whaou !!  The Hyland Summit 2023(…)

Locales, collations, encodings and the PostgreSQL sort order (2) – sorting strings

In the last post we’ve looked at how you can tell initdb which character set and locale it should use for the initial databases. In this post we’ll look at how you(…)

Redis: How transactions work in Redis

Introduction: Redis allows you to use many commands to create and administrate your database. There is especially one useful feature which which allows you to execute a series of commands as a single unit of work: The Redis transactions! In(…)

How can LC_* localisation environment variables can break Oracle datapatch

[ORA-20001] How can LC_* localisation environment variables can break Oracle datapatch(…)

Monitor Alfresco with Zabbix

In this blog post, I will share a few obstacles I have encountered while trying to monitor a complete Alfresco setup with all these components. As an overview, here are the templates I will use: Apache ActiveMQ by JMX Apache(…)

Locales, collations, encodings and the PostgreSQL sort order (1) – basics

When it comes to sorting strings it is all about locales and how PostgreSQL is using them. PostgreSQL uses the locales provided by the underlying operating system, by default this is “C” or “POSIX”. To see(…)

What is the difference between session_user and current_user in PostgreSQL?

When you want to know the currently connected user in PostgreSQL for your session there are two system information functions which seem to do the same thing. There is “session_user” and there is “current_user”. So what is the difference between(…)