Daniel Westermann

PostgreSQL 19: The “WAIT FOR” command

When you go for replication and you don’t use synchronous replication there is always a window when data written on the primary is not yet available in the replica. This is known as “replication lag” and can be monitored(…)

PostgreSQL 19: Two nice little improvements: log_autoanalyze_min_duration and search_path in the psql prompt

Two nice little improvements have been committed for PostgreSQL 19. The first one is about logging the duration of automatic analyze while the second one is about displaying the current search_path in psql’s prompt. Lets start with the(…)

From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 2 – Records, outputs and constraints

In the last post we’ve learned the basics for migrating a sample procedure from PL/SQL to PL/pgSQL. In this post we’ll actually start with migrating the code. The first step in the original procedure was(…)

From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 1 – Basics

Migrating from one database system to another is not an easy task. It might be easy if you only need to migrate the data, but as soon as you have business logic in the database this can become a(…)

Patching SUSE Multi Linux Manager

In the last post about SUSE Multi Linux Manager we had a look at how you can schedule OpenSCAP reports using the API. In this post we’ll look into something very basic: How can you(…)

Scheduling OpenSCAP reports in SUSE Multi-Linux Manager

As we’ve recently supported some customers on SUSE Multi Linux Manager I’d like share something which was not as easy to implement as it appeared to be in the first place. But first of all,(…)

Using dlt to get data from Db2 to PostgreSQL

For a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is(…)

2025.pgconf.de recap

( note: I am writing this as member of the pgconf.de organization team, and not as a dbi services employee ) After almost half a year of planning and preparation PostgreSQL Conference Germany 2025(…)

Getting started with Open WebUI

Everybody is talking about AI, RAG and language models today. A lot of people are using ChatGPT or other tools to get answers(…)

PostgreSQL 18: Support for asynchronous I/O

This is maybe one the biggest steps forward for PostgreSQL: PostgreSQL 18 will come with support for asynchronous I/O. Traditionally PostgreSQL relies on the operating system to hide the latency of writing to disk, which is done synchronously and(…)