Understanding Standby Clusters in Patroni: Cross-Datacenter Disaster Recovery for PostgreSQL
If you run PostgreSQL in production at any scale, you’ve probably already adopted Patroni to manage high availability within a […]
Inside Patroni’s replicatefrom: How Cascading replica self-heal when their upstream fails
If you run PostgreSQL at scale with Patroni, you’ve probably hit the point where every replica streaming directly from the
When a Disk Expansion Brought Down a PostgreSQL Archive Pipeline
Production database incidents rarely look like what you expect. They don’t arrive with sirens. They accumulate quietly — a mount
When a Disk Expansion Brought Down a PostgreSQL Archive Pipeline Read Post »
What Production Teams Need to Know About May ‘26 Postgres Minor releases
The CVEs That Matter Most in Production 🔴 Critical: Path Traversal in pg_basebackup & pg_rewind (CVE-2026-6475) Who’s hit: Anyone running
What Production Teams Need to Know About May ‘26 Postgres Minor releases Read Post »
Setting Up Logical Replication on PostgreSQL (Windows)
Welcome to our latest blog!! In the real world, not every PostgreSQL deployment gives you the freedom to choose your
Setting Up Logical Replication on PostgreSQL (Windows) Read Post »
Who Owns Connection Pooling? The App Team vs. DB Team Debate
Every engineering org eventually runs into this conversation. A production incident fires, connection errors start flooding the logs, and someone
Who Owns Connection Pooling? The App Team vs. DB Team Debate Read Post »
Terabyte-Scale PostgreSQL Logical Replication: The Challenges nobody warns us about
PostgreSQL logical replication is a powerful feature — elegant in concept, battle-hardened in design. But when we push it to
Terabyte-Scale PostgreSQL Logical Replication: The Challenges nobody warns us about Read Post »
The Ultimate PostgreSQL Power-User Manual: Why Postgres is a toolbox, Not Just a Database
In the high-stakes world of High Availability (HA), meticulous performance tuning, and mission-critical production systems, veteran Database Administrators and System
How Patroni Brings High Availability to PostgreSQL
PostgreSQL gives you excellent streaming replication. You can have a primary node streaming WAL (Write-Ahead Log) to one or more
How Patroni Brings High Availability to PostgreSQL Read Post »
Building Bridges with the PostgreSQL Community: Our Journey
At the heart of what we do is a deep belief that great technology thrives in great communities. That’s why
Building Bridges with the PostgreSQL Community: Our Journey Read Post »
Understanding PostgreSQL Row-Level Locking: A Practical Guide
When multiple users try to update the same data simultaneously, chaos could ensue without proper coordination. PostgreSQL’s row-level locking mechanism
Understanding PostgreSQL Row-Level Locking: A Practical Guide Read Post »
PostgreSQL Failover in Action: Testing VIP Management and Split-Brain Detection Without Keepalived
Our journey to PGConf India has officially begun! Starting today, we’re launching a daily blog series that will run every
Understanding Repmgr Architecture: Fencing & VIP Management Challenges
We all know that Repmgr (Replication Manager) is an open-source tool designed to manage PostgreSQL replication and facilitate automatic failover.
Understanding Repmgr Architecture: Fencing & VIP Management Challenges Read Post »
Battle-Tested: Being a PostgreSQL DBA
Being a PostgreSQL DBA means living in a world where production issues don’t arrive on a schedule. Over the past
Battle-Tested: Being a PostgreSQL DBA Read Post »
From Gigabytes to Terabytes: The PostgreSQL Survival Guide
There’s a moment in every database team’s journey when the usual PostgreSQL tuning advice stops working. Your shared_buffers are optimized.
From Gigabytes to Terabytes: The PostgreSQL Survival Guide Read Post »
Optimizing PostgreSQL Delete Operations: A Deep Dive into Performance Troubleshooting
Our client was experiencing frustratingly slow delete operations in their PostgreSQL database. What should have been a monthly data cleanup
Optimizing PostgreSQL Delete Operations: A Deep Dive into Performance Troubleshooting Read Post »
Production-Ready Selective Logical Replication: Non-Partitioned to Partitioned Tables in PostgreSQL
In modern database architectures, it’s common to maintain separate environments for transactional operations and analytical workloads. One challenging scenario is
A Year of PostgreSQL Excellence – OSDB’s Blogging Journey
As we close out 2025, we’re thrilled to reflect on an incredible year of knowledge sharing, community building, and technical
A Year of PostgreSQL Excellence – OSDB’s Blogging Journey Read Post »
November ’25 PostgreSQL Minor Release: What You Need to Know
On November 13th, 2025, the PostgreSQL Global Development Group released updates across all supported versions: 18.1, 17.7, 16.11, 15.15, 14.20,
November ’25 PostgreSQL Minor Release: What You Need to Know Read Post »
Resolving Replica Identity Issues After Dropping Logical Replication
Recently, one of our clients encountered a perplexing issue with their PostgreSQL database. They had been using logical replication and
Resolving Replica Identity Issues After Dropping Logical Replication Read Post »
Postgres HA Architecture: Eliminating SPoF with Keepalived
Production PostgreSQL deployments demand high availability. Applications requiring four or five nines of uptime need resilient database clusters built on
Postgres HA Architecture: Eliminating SPoF with Keepalived Read Post »