Database management

CloudNativePG – The kubectl plugin

As we’re getting more and more familiar with CloudNativePG, now it’s time to get more information about our cluster, either for monitoring or troubleshooting purposes. Getting information about the general state of our cluster can be easily done by using(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

CloudNativePG – PostgreSQL extensions

Now that we know how we can configure the PostgreSQL instance and access control, we’re going to look at what you can do when it comes to PostgreSQL extensions with CloudNativePG. As we have a running(…)

CloudNativePG – Configuring the PostgreSQL instance

In the last post we’ve created a more detailed version of the cluster definition for CloudNativePG. This gave us a PostgreSQL cluster with enabled data checksum, the correct locale, an increased size of the WAL segments and the possibility(…)

CloudnativePG – Bootstrapping an empty cluster

In the last post we’ve created a very simple three node PostgreSQL cluster using CloudNativePG and this was really easy to do. While this is great to get started quickly, you usually want to have(…)

CloudNativePG on minicube on openSUSE Leap Micro 6

Some time ago I’ve written a small blog about how to get openSUSE Leap Micro 6 up and running. As one of the use cases for this distributions is to run container workloads, the next natural step is to(…)

PostgreSQL and huge pages on Windows

Configuring the operating system for huge pages on Linux and make PostgreSQL using it is quite simple and straight forward. Here are two quite old post on how to do this, one for Debian systems, one for(…)

Simulate (Transparent Tablespace Encryption) TDE on Oracle Standard Edition

by Alexandre Nestor Introduction The Oracle database Standard Edition do not have the Transparent Tablespace Encryption (TDE) feature which is a part of ASO (Advanced Security), and ASO is availabale only on Entreprise Edition version. But encryption can still be(…)

Time to test: PostgreSQL 17beta1 is there

It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of PostgreSQL(…)

MariaDB – Repair Replication Through DB Restore (mariabackup)

Introduction This blog is a follow-up to my previous post: MariaDB Repair Replication through DB Restore. A client recently experienced a crash on the database slave in their MariaDB cluster within their QA environment. I successfully restored the database(…)