Database Administration & Monitoring

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

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

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

Redis:Hands-on with Redis ,train with Redisinsight on Windows!

What is Redis? Redis which stands for Remote Dictionary Server is “an in-memory data structure store, used as a distributed, in-memory key–value database, cache and message broker, with optional durability” It is a Nosql database which offer you(…)

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

New cast testing functions for PostgreSQL 16

As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be(…)

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures,(…)

PostgreSQL 16: More flexibility for vacuum and analyze

Update 14-Dec-2022: Please see this post, the content here is not anymore up to date. While PostgreSQL 15.1 was released some weeks ago PostgreSQL 16 is already under(…)

Azure SQL Managed Instance link feature overview

In one of my last blog-posts I spoke about Striim which is a data replication platform that can be used for migrations but also for offloaded reporting or even real-time analytics.A new Azure feature, currently on preview, named(…)