Database Administration & Monitoring

Easy failover and switchover with pg_auto_failover

One the really cool things with PostgreSQL is, that you have plenty of choices when it comes to tooling. For high availability we usually go with Patroni, but there is also pg_auto_failover(…)

Oracle 21c Security : Gradual Database Password Rollover

By Mouhamadou Diaw Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of(…)

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

By Mouhamadou Diaw In my previous blog I was testing the creation of a new Oracle 21c database. In this blog I am talking about two changes about the security. In each new(…)

Oracle 21c : Create a New Database

By Mouhamadou Diaw Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it 1 [oracle@oraadserver admin]$ dbca(…)

A typical ODA project (and why I love Oracle Database Appliance)

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would(…)

Incremental materialized view maintenance for PostgreSQL 14?

Since PostgreSQL 9.3 there is the possibility to create materialized views in PostgreSQL. PostgreSQL 9.4 (one year later) brought concurrent refresh which already is a major step forward as this allowed querying(…)

Even faster data loading with PostgreSQL 14? wal_level=none

PostgreSQL is already very fast with loading loading large amounts of data. You can follow this post to get some recommendations for loading data as fast as possible. In addition you can create(…)

An Introduction to Pester – Unit Testing and Infrastructure checks in PowerShell

Introduction If you never heard of it, Pester is a PowerShell module, written in PowerShell. It’s a framework for writing and running unit tests, integration tests, and also infrastructure checks as we will see in a moment.

Convert private key generated via OCI Console to ppk

I am pretty new on the Oracle Cloud Infrastructure technology, so maybe I am talking about something you already know. But anyway I prefer to share this case: it can help if you encounter the same(…)

Installing MySQL Database Service (MDS)

On a previous blog post, we saw how to create an account on the Oracle OCI using the Oracle Cloud Free Tier offer and then how to(…)