Topic

Update

A collection of 8 issues

Oracle: cleanup after patching (in-place)

Patching your Oracle systems is essential for a stable, secure and up-to-date environment. Oracle recommends to patch out-of-place, which means that you just add another software home and switch to it. But in many environments, traditional (in-place) patching is still needed. So the software needs to be stopped, the patch

PostgreSQL: Upgrade to version 18 in-place

This is how I update my PostgreSQL instances to 18 using Docker Compose and PgAutoUpgrade

PostgreSQL: Update extensions

This is how to update an extension in PostgreSQL

CheckMk: Upgrade CheckMk using Docker Compose

This is about how to update or upgrade CheckMk inside a Docker container.

Oracle: Which updates to install

In my IT carreer, I often come to new customers I didn't know before. So I don't know their infrastructure. As I'm a DBA, I'm not interested in application servers (besides telling the customer that Operating Systems and standard applications should always

Oracle: Upgrade from 12.1.0.1 using autoupgrade.jar takes ages

Last year, when I upgraded many Oracle databases to 19c, I had a few databases which were still on Oracle 12.1.0.1. In case that you forgot what 12.1.0.1 meant for Oracle and all customers: * Until 12.1.0.1, we had Enterprise Edition, Standard

Oracle: Timezone upgrade - the easy way

From time to time, countries change their time zone, or the daylight saving time changes (in Germany, we wait for that since years). As some date columns include this information - like TIMESTAMP WITH TIME ZONE, they have to be updated. These updates are called Timezone upgrades. The standard way

PostgreSQL: inplace upgrade in Docker container

As I wrote in a older blog entry, we cannot just change the PostgreSQL image of a Docker container to a higher major version. Restarting the container like that will lead to a not running PostgreSQL container, as older data will not start using newer binaries. But there's