BE SHARING

Daniel Westermann

PostgreSQL 15: Add row filters for logical replication

24.02.2022 by Daniel Westermann

My last post about logical replication in PostgreSQL was in 2017 before PostgreSQL 10 was released later that year. There have been many enhancements to logical replication since then and today we'll look at a new features(…)

Database Administration & Monitoring

PostgreSQL 15: New option for NULL handling in unique constraints

03.02.2022 by Daniel Westermann

Another nice feature was just committed for PostgreSQL 15: Add UNIQUE null treatment option (discussion here, commit details here). What is it about? The answer is quite easy if we do a little example(…)

Database Administration & Monitoring

PostgreSQL 15: New function to list flags associated to GUCs

31.01.2022 by Daniel Westermann

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(…)

DevOps

Do you know Rancher Desktop?

25.01.2022 by Daniel Westermann

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(…)

Database Administration & Monitoring

Patching an IBM Db2 instance

21.01.2022 by Daniel Westermann

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,(…)

Database Administration & Monitoring

New options for pg_basebackup in PostgreSQL 15

21.01.2022 by Daniel Westermann

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(…)

Database Administration & Monitoring

Setting up IBM Db2 on Linux – root installation

20.01.2022 by Daniel Westermann

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(…)

Database Administration & Monitoring

Getting explain plans out of Db2

20.01.2022 by Daniel Westermann

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(…)

Database Administration & Monitoring

Migrating a CentOS 7 EC2 instance to Rocky Linux 8

18.01.2022 by Daniel Westermann

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(…)

Database Administration & Monitoring

Setting up IBM Db2 on Linux

14.01.2022 by Daniel Westermann

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(…)