Infrastructure at your Service

All Posts By

Daniel Westermann

Daniel Westermann

Patching an IBM Db2 instance

By | Database Administration & Monitoring | No Comments

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, while Fix Packs come with bug fixes only. Keeping your database installations up to date is important, that applies to all products. As my system is running 11.5 the page which gives me all the information is this,…

Read More
Daniel Westermann

New options for pg_basebackup in PostgreSQL 15

By | Database Administration & Monitoring | No Comments

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 to now, pg_basebackup will send the result always to the node/machine where you started it. That means: If you started pg_basebackup on your client or backup machine, then the resulting base backup will go there. No other options…

Read More
Daniel Westermann

Setting up IBM Db2 on Linux – root installation

By | Database Administration & Monitoring | 2 Comments

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 limitations. Most installations, I guess, are root installations, especially if you want to run more than one instance on a host, and you want to have them started automatically when the systems comes up. Lets see how that works.

Read More
Daniel Westermann

Migrating a CentOS 7 EC2 instance to Rocky Linux 8

By | Database Administration & Monitoring | No Comments

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 customer and all are running as virtual machines. The very same customer has many EC2 instances running on CentOS 7. Migrating away from CentOS 7 is one of the next tasks to complete, as CentOS 7 will reach end of life…

Read More
Daniel Westermann

Setting up IBM Db2 on Linux

By | Database Administration & Monitoring | 2 Comments

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 don’t know about it, or these databases are managed by other teams than those we work with. And now we have a request for supporting someone with performance issues on Db2, and requests are showing up from people…

Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni nodes and later on configure Zabbix to monitor the PostgreSQL instances.

Read More
Daniel Westermann

PostgresBuild2021 – questions feedback (1)

By | Database Administration & Monitoring | 2 Comments

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 thought about. The topic of my talk was “An introduction to server side programming” and I wanted to give people easy examples about how to write procedures and functions in PostgreSQL. It was not about control structures like…

Read More
Daniel Westermann

Open source monitoring solutions (1) – Zabbix server setup

By | Database Administration & Monitoring | No Comments

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious way is trying to integrate into the existing solution. If nothing is there already, you have plenty of choices. You can find some of them on this blog, but the list is quite old. Usually, PostgreSQL is not…

Read More
Daniel Westermann

Switching from CentOS 8 to Red Hat 8

By | Database Administration & Monitoring | 2 Comments

We have quite a few customers still running on CentOS 8 and you probably already are aware that CentOS 8 will be end of life by the end of this year. This forces a lot of companies to either switch to an alternative or to stick with CentOS stream. For most enterprise workloads CentOS stream is not a solution as it is rolling release, and if you want to keep a Red Hat compatible enterprise…

Read More