Postgres

Oct 25, 20234 min read

Bi-directional Replication: Conflict Resolution

Introduction It will happen. Despite all of the compensating controls, care, and precautions taken, it will happen. At some point in...

64 views0 comments

Oct 5, 20234 min read

Bi-directional Replication: The Rest of the Story

Introduction Throughout my three decades of experience in dealing with enterprise databases, the concept of bi-directional...

54 views0 comments

Oct 5, 202312 min read

Recovering Data from a Split-Brain Incident

Introduction The best practice when deploying Patroni alongside PostgreSQL, and potentially for standalone PostgreSQL setups with...

195 views0 comments

Sep 13, 20236 min read

Bi-directional Replication: Am I in-sync?

Introduction Years of administering databases employing logical replication solutions like Shareplex or GoldenGate have given rise to the...

17 views0 comments

Sep 13, 20236 min read

Bi-directional Replication: PostgreSQL is ready. Are you?

Introduction Postgres is a robust and popular open-source relational database management system known for its advanced features and...

47 views0 comments

May 11, 20233 min read

From Code to SQL: Mortgage Amortization Schedule

A recent conversation with a teammate brought me back to my roots as a developer in the mortgage loan industry. Thinking back to some of...

628 views0 comments

Nov 2, 20223 min read

Database Replication for Postgres/Oracle using Debezium and Kafka

Hands on tutorial of setting up replication between Oracle and Postgres (both directions) using Debezium and Kafka.

91 views0 comments

Sep 30, 20228 min read

The Missing Guide for pgBouncer Metrics

Introduction Several pgBouncer metrics are critically important. However, there is often a lack of understanding as to what these...

162 views0 comments