Tag: step by step

Posted on

PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest

red and blue abstract painting

If you work with PostgreSQL in production, backups are not optional.

In this lab, I built a complete PostgreSQL 18 backup and recovery environment on Ubuntu 24.04 and tested all three major backup approaches:

  • logical backups with pg_dump
  • physical backups with pg_basebackup
  • production-grade backups with pgBackRest, including WAL archiving and Point-In-Time Recovery (PITR)

Everything was tested on a real VM with actual recovery drills — not simulations.

Continue reading “PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest”
Posted on

How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium

vibrant abstract light streaks in motion

TL;DR: Debezium reads Oracle's redo logs through LogMiner, publishes every change as a Kafka event, and a JDBC sink connector applies those events to PostgreSQL in real time.
The result is a transparent, replayable replication pipeline you can run for weeks before cutover — useful for any Oracle to PostgreSQL migration that needs zero or near-zero downtime.
This post walks through a working setup end to end, on real Oracle and PostgreSQL servers, with a self-contained banking schema you can paste and reproduce.

Continue reading “How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium”