A step-by-step guide to upgrading OpenSSH on CentOS to mitigate CVE-2024-6387

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

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.

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.

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.

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