Daniel Westermann

PostgreSQL 15: New function to list flags associated to GUCs

As development of PostgreSQL 15 is on its way, more and more features get committed. Today we'll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you(…)

Do you know Rancher Desktop?

Today I stumbled across Rancher Desktop and thought I'll give it a try. If blogged about Rancher in the past but all those blogs talked about the full blown Rancher project. Rancher Desktop brings(…)

Patching an IBM Db2 instance

The next task in my journey with DB2 is to apply a patch. In the world of DB2 there are Modification Packs and Fix packs. As far as I understand it, Modifications Packs come with new features,(…)

New options for pg_basebackup in PostgreSQL 15

If, and you should, are doing base backups of your PostgreSQL instances you've probably used pg_basebackup. Another use case for pg_basebackup is to create a starting point for replicas when you are setting up streaming replication. Up(…)

Setting up IBM Db2 on Linux – root installation

In the first post about Db2 I went for the non-root installation method. While this is great if you want to get started fast and to do some tests this also comes with(…)

Getting explain plans out of Db2

The last post about Db2 was about getting it up and running. As the issue we had to solve was about performance, getting an explain plan for the problematic statement(s) was the obvious step to do. In(…)

Migrating a CentOS 7 EC2 instance to Rocky Linux 8

Some time ago I've written about migrating a CentOS 8 machine to Red Hat 8, because CentOS 8 reached end of life last December. We did that for all CentOS 8 installations at that(…)

Setting up IBM Db2 on Linux

My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL/application level. I've never done an installation of Db2 as most of our customers either don't use it, or we(…)

Open source monitoring solutions (2) – Zabbix agents and PostgreSQL monitoring

By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it's back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself(…)

PostgresBuild2021 – questions feedback (1)

PostgresBuild2021 is currently ongoing and as usual, I had questions after my talk I could not immediately answer. One of the best ways to learn, is to present a topic. There are for sure questions you never(…)