Database management

What is Forgejo and getting it up and running on FreeBSD 15

In recent customer projects I had less to do with PostgreSQL but more with reviewing infrastructures and give recommendations about what and how to improve. In all of those projects GitLab is used in one way(…)

OGG-10556 when starting extract from GoldenGate 23ai web UI

Another day, another not-so-documented GoldenGate error, this time about the OGG-10556 error, which I had when setting up replication on a new GoldenGate installation. After making changes from the web UI in an extract, I ended with the following error(…)

Extend Session Timeout in Oracle GoldenGate Microservices Web UI

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways of(…)

Shell and Perl in one script

To run a Perl script directly like a binary from within the shell, you have to set the executable flag on the script Add the shebang line (the 1st line (#!...) specifiyng the interpreter to use) #!/usr/bin/env perl #!/usr/bin/perl(…)

OGG-00423 when performing initial load with GoldenGate 23ai

Very quick piece of blog today to tackle the OGG-00423 error. There is not much information online on the matter, and the official Oracle documentation doesn’t help. If you ever stumble upon an OGG-00423 error when(…)

SQL Server 2025 release

Microsoft has announced the release of SQL Server 2025. The solution can be downloaded using the following link: https://www.microsoft.com/en-us/sql-server/ Among the new features available, we have: The introduction of the Standard Developer Edition, which offers the same features as(…)

ORA-44001 when setting up GoldenGate privileges on a CDB

I was recently setting up GoldenGate for a client when I was struck by a ORA-44001 error. I definitely wasn’t the first one to come across this while playing with grants on GoldenGate users, but nowhere could I find the(…)

PostgreSQL 19: Logical replication of sequences

Logical replication in PostgreSQL got a lot of features and performance improvements over the last releases. It was introduced in PostgreSQL 10 back in 2017, and PostgreSQL 9.6 (in 2016) introduced logical decoding which is the basis for logical replication.

PostgreSQL 19: The “WAIT FOR” command

When you go for replication and you don’t use synchronous replication there is always a window when data written on the primary is not yet available in the replica. This is known as “replication lag” and can be monitored using(…)

Setting up TLS encryption and authentication in MongoDB

When securing a MongoDB deployment, protecting sensitive data is paramount. MongoDB supports encryption throughout the lifecycle of the data, with three primary types of data encryption : Encryption in transit Encryption at rest Encryption in use Among these, encryption in(…)