Database management

How to submit a talk for a conference

I already did some talks at conferences and I had already the honor to select talks for a conference. During this talk selection I found some excellent examples on how to do to a proposal, but unfortunately also some examples(…)

PostgreSQL 16: reserved_connections

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)

ChatGPT vs Oracle DBA

Is ChatGPT (AI chatbot) useful for an Oracle DBA?(…)

Converting from Unix timestamps to “real” timestamps in PostgreSQL

Recently we’ve been asked how an application can be changed from using Unix timestamps to PostgreSQL timestamps. It is still not so uncommon to store dates and times in numeric data types,(…)

Patching ODA HA from 19.10 to 19.17

By Mouhamadou Diaw In this blog I am describing an ODA HA (serveroda1 and serveroda2) patch from 19.10 to 19.17. The process is the same that patching a non-HA ODA. Few tasks may need to be done on both(…)

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (1) – The server

Most of you probably heard of Red Hat Satellite, a product which is used to manage Linux infrastructures. Maybe you also heard about SUSE Manager, which does more or less the same(…)

Fast setup of a two node repmgr cluster with auto failover

This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the(…)

Applying RU on Enterprise Manager 13c R5

By Mouhamadou Diaw We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to OEM 13cR5 Update(…)

PostgreSQL 16: Further reducing tasks that require superuser

In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still in(…)