Database management

Reading data from PostgreSQL into Oracle

Usually the requests we get are around getting data from Oracle into PostgreSQL, but sometimes also the opposite is true and so it happened recently. Depending on the requirements, usually real time vs. delayed/one-shot, there are several options when you(…)

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.

Oracle Grid Infrastructure 26ai/ ASM upgrade from 19c one node.

This is second part of 26ai migration blog. We will upgrade here one 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(…)

Database upgrade to AI Database 26ai (23.26.1) for Linux x86-64 upgrade from 19C in 3 steps using gold images.

This tutorial showing simple database upgrade to 26ai using traditional method and autoupgrade tool, For operational databases please properly test and plan your upgrade. https://docs.oracle.com/en/database/oracle/oracle-database/26/fppad/upgrading-oracle-database-software.html This is one from 3 Articles related to 26.1 upgrade: Database upgrade(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (2) TDE

In the last post we’ve looked at how you you get EDB Postgres Extended server installed on your system. In contrast to the version provided by Fujitsu, TDE needs to be enabled when you initialize a(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (1) Setup

We’ve already briefly looked at Fujitsu Enterprise Postgres (here and here) when it comes to TDE (Transparent Data Encryption) in PostgreSQL. In this and the next post we’ll look at(…)

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (2) TDE

In the last post we did the setup of Fujitsu Enterprise Postgres so we’re now ready to look at how TDE is implemented in this distribution of PostgreSQL. The unit of encryption in this version of(…)

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (1) Setup

While TDE (Transparent Data Encryption) is considered a checklist feature in some parts of the PostgreSQL community this topic comes up all over again. The same is true with our customers, it doesn’t matter at all if it technically makes(…)

PostgreSQL: Transaction IDs and Virtual Transaction IDs

In the last post we’ve looked at the basics when it comes to row locking in PostgreSQL and how that looks like in pg_locks. In this post we’ll look at transaction IDs and virtual transaction IDs(…)

PostgreSQL: An introduction to row locking

Sometimes it is necessary to troubleshoot locks in PostgreSQL to figure out what is going on in the system. While locks are important and necessary in a database system, too many locks can also be an issue, performance wise and(…)