Database management

Oracle 23ai New Backup & Recovery Features

In this article I will give a short overview of some Backup & Recovery features in the new Oracle 23ai database. Meanwhile there are more than 300 new features in Oracle 23ai most of them reflecting artificial intelligence. I will(…)

CloudNativePG – Scaling up and down

By now, if you followed the previous posts (here, here, here, here and here), we know quite a bit about how to use(…)

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