All articles

Grid Clusterware 26ai 2 node RAC upgrade from 19c rolling forward

This is third part of 26ai migration blog. We will upgrade here 2 node Clusterware with ASM in 19c. We will use newest 23.26.1 GoldImages from oracle support. This tutorial showing main steps how to perform upgrade, its not procedure(…)

Creating an Oracle Cloud Infrastructure VM Using the CLI

Oracle Cloud Infrastructure (OCI) provides an easy-to-use command line interface named oci, with which you can do a lot of administrative tasks. Let’s see in this blog how to create virtual machines in OCI with this. Setting up oci-cli(…)

pgvector, a guide for DBA – Part 2: Indexes (update march 2026)

Introduction In Part 1 of this series, we covered what pgvector is, how embeddings work, and how to store them in PostgreSQL. We ended with a working similarity search — but on a sequential scan. That works fine for(…)

PostgreSQL 19: pg_dumpall in binary format

One of the limitation of pg_dumpall up to PostgreSQL version 18 is, that you can only dump in text mode. While pg_dump can dump in various formats (plain,custom,tar and directory) since ages.

PostgreSQL Anonymizer: Simple Data Masking for DBAs

Sensitive data (names, emails, phone numbers, personal identifiers…) should not be freely exposed outside production. When you refresh a production database to a test or staging environment, or when analysts need access to real-looking data, anonymization becomes critical. The PostgreSQL(…)

Relocate trail files with convchk when migrating GoldenGate to the Microservices Architecture

Depending on the location of your GoldenGate trail files, you might have to use the convchk utility to relocate them before migrating to the Microservices Architecture. Oracle has the following restrictions for using the migration(…)

Monitoring PostgreSQL on Windows with PgHero and Docker

I know, I know, PostgreSQL usually feels more at home on Linux. But guess what? PgHero works just fine on Windows too, and I gave it a try myself. If you’re running PostgreSQL in a Docker container, this setup is(…)

Dctm – Detect and analyze slow SQL queries

Documentum is a powerful but also complex software. Therefore, debugging performance issues often comes down to being able to implement and review various traces. In this blog, I will talk about how you can detect and analyze slow SQL queries(…)

Production-ready GoldenGate REST client in Python

In this blog, I provide GoldenGate administrators with a fully working, production-ready Python client to efficiently handle GoldenGate REST API calls. From extract creation to user management, it has never been easier to manage and monitor your GoldenGate deployments !(…)

RAG Series – Embedding Versioning LAB

Introduction This is Part 2 of the embedding versionin, in Part 1, I covered the theory: why event-driven embedding refresh matters, the three levels of architecture (triggers, logical replication, Flink CDC), and how to detect and(…)