Daniel Westermann

The adaptable Linux Platform (ALP)

This is about something you maybe didn’t hear much yet: The openSUSE project and SUSE are working on a new enterprise operating system: ALP, the adaptive Linux Platform.

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (1) – The server

Most of you probably heard of Red Hat Satellite, a product which is used to manage Linux infrastructures. Maybe you also heard about SUSE Manager, which does more or less the same(…)

PostgreSQL 16: Further reducing tasks that require superuser

In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still in(…)

New cast testing functions for PostgreSQL 16

As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be returned(…)

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while developing(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures, nor(…)

PostgreSQL 16: More flexibility for vacuum and analyze

Update 14-Dec-2022: Please see this post, the content here is not anymore up to date. While PostgreSQL 15.1 was released some weeks ago PostgreSQL 16 is already under active development. Two(…)

An introduction to OMrun – 2 – Working with parameters

In the last post we compared the list of databases in the same PostgreSQL cluster using OMrun. The setup for this was pretty simple: We’ve defined the environment using the PostgreSQL Data Adapter and created the(…)

An introduction to OMrun – 1 – A simple data comparison with the PostgreSQL Adapter

With the integration of OMIS into dbi services we also got a new product: OMrun. OMrun is all about data, especially comparing, validating and anonymizing data from various sources against various targets.