Database Administration & Monitoring

PostgreSQL: When wal_level to logical

By Mouhamadou Diaw wal_level determines the quantity of information written to the WAL. With PostgreSQL 11 the parameter wal_level can have 3 values: -minimal : only information needed to recover from a crash or an immediate shutdown -replica(…)

Looping sssd_nss

Often Linux systems are connected to LDAP via sssd. A high CPU consuming sssd can be seen in top, like below ( e.g. 89.4 % CPU usage): 9020 root 20 0 1296344 466780 333364 R 89.4 0.8 41:20.17(…)

Red Hat Forum Switzerland 2019

Today (actually right now) we are a proud sponsor of the Red Hat Forum Switzerland 2019 in Geneva. With around 300 people attending this is quite a huge event and we had a lot of interesting(…)

Deploying SQL Server 2019 AGs on K8s with helm charts

This write-up follows my first article about helm chart with SQL Server. This time, I would like to cover the availability groups topic and how to deploy them with helm charts. In fact, to go(…)

Copy or Migrate a SSISDB environment

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate(…)

Compile additional packages for Oracle VM Server

I needed a special package on my OVM Server 3.4.6. The package is called fio and is needed to do some I/O performance tests. Unfortunately, OVM Server does not provide any package for compiling software and installing additional software(…)

PostgreSQL 12, pg_stat_statements_reset for userid, queryid and dbid

PostgreSQL 12 will give you more control on resetting statistics gathered by pg_stat_statements. When you check the documentation for PostgreSQL 11 (as linked in the previous sentence) you will see that the function has the following(…)

Documentum 7+ internal error during installation or upgrade DBTestResult7092863812136784595.tmp

This blog will go straight to the topic. When upgrading/installing your content server to 7+, you may experience an internal error with a popup telling you to look into a file called something like: DBTestResult7092863812136784595.tmp In fact, the installation process(…)

How to build a dummy resource plan

Often switching off resource plan feature of Oracle database is desired. Unfortunately setting parameter RESOURCE_MANAGER_PLAN to empty string does not help, because it does not disable switching to another resource plan, e.g. with dbms_scheduler. Following procedure prevents this switching.

Using Ansible to bring up a three node Patroni cluster in minutes

Automation is key today, nobody wants to do the same tasks over and over and again. Cloud without automation is not even possible. There are several tools around that help with automation and one of the most popular is(…)