Debugging PgLogical Replication


Learn how to debug PgLogical replication issues in PostgreSQL, covering both provider and receiver sides.
Read more ⟶

Upgrading PostgreSQL from 14 to 15 using Patroni in Kubernetes


This article provides a detailed guide on how to upgrade PostgreSQL from version 14 to 15 using Patroni in Kubernetes. It covers the necessary preparations, including enabling in-place upgrades and failsafe mode, starting the upgrade, and fixing broken pglogical replication. It also addresses a specific issue related to pglogical replication and provides a solution for it.
Read more ⟶

Rapid WAL Growth in Postgres PG15 on Kubernetes


Dive into a deep tech exploration of dealing with rapidly growing Write-Ahead Logging (WAL) in PostgreSQL PG15 within a Kubernetes environment. Learn about the challenges, mistakes made, and the recovery process, complete with practical SQL queries and commands. Essential reading for database administrators and engineers.
Read more ⟶

Enabling IRSA for ServiceAccounts in Kops


Learn from my experience on how to enable IRSA (IAM Roles for ServiceAccounts) support in Kops managed clusters, and leverage AWS authentication and authorization for your applications.
Read more ⟶

Hello World!


First blog post here. Hugo initial setup and simple hosting on Digital Ocean static apps.
Read more ⟶