All articles

GoldenGate 26ai Logs Explained

GoldenGate logs are a powerful source of information when troubleshooting or analyzing your deployments. However, there is at least one log file per service in the Microservices Architecture. This means that for a GoldenGate setup with multiple deployments, you(…)

Create Distribution Paths in NGINX-Secured GoldenGate 26ai

Setting up a distribution path is an important step when connecting two GoldenGate deployments. However, there are so many connection options that it’s hard to know how to proceed. In this blog, I will present the way to connect(…)

PostgreSQL 19: Online enabling of data checksums

Since PostgreSQL 18 was released last year checksums are enabled by default when a new cluster is initialized. This also means, that you either need to explicitly disable that when you upgrade from a previous version of PostgreSQL or(…)

M-Files didn’t fix your problem, your organization did.

Last week a wrote about the reasons why ECM projects fails. M-Files is a wonderful tool and probably my favorite ECM, but it won’t solve your problem. Companies that(…)

PostgreSQL 19: get_*_ddl functions

PostgreSQL already comes with plenty of system information functions to reconstruct the commands to create various objects, e.g. constraints or indexes. Starting with PostgreSQL 19 more functions will be available, namely those: pg_get_database_ddl pg_get_role_ddl pg_get_tablespace_ddl(…)

PostgreSQL 19: json format for “copy to”

PostgreSQL already has impressive support for working with data in json format. If you look at the jsonb data type and all the built-in functions and operators you can use, there is so(…)

OGG-30007 : How To Register Certificates In GoldenGate ?

After working on a GoldenGate deployment recently, I felt that the OGG-30007 error would be worth writing about. This error happens when registering certificates in GoldenGate. Whether you do it from the web UI or(…)

PostgreSQL 19: The “repack” command

Before PostgreSQL 19 you had two commands to completely rewrite a table: Either you can use the “vacuum full” or the “cluster” command to achieve this. Both operations are blocking and(…)

Why ECM Projects fail (even with good tools)

Today, I would like to take a step back and think about failure, because it’s part of life and sometimes things don’t go as planned. Analyzing failures can help to prevent them from happening again. Firstly, in most(…)

Overcome GoldenGate 26ai Bug On Custom Profiles

In GoldenGate, processes have a few options that can be managed to fit your needs. When creating an extract, for instance, you can act on the following parameters: autoStart.enabled: whether the process will start automatically after the Administration Server(…)