Database Administration & Monitoring

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.

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

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

SQL Server 2022 CU23: Database Mail is broken, but your alerts shouldn’t be

SQL Server 2022 CU23 bug freezes your emails? Bypass Database Mail using dbatools and PowerShell to resend blocked alerts.

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