PostgreSQL Failover Testing: Real Scenarios (Part 4)
Test automatic and manual PostgreSQL failover. Kill the primary, watch Orchestrator promote, verify ProxySQL reroutes. Real outputs.
Orchestrator PostgreSQL Failover Configuration (Part 3)
Install Orchestrator 4.30.2 for PostgreSQL. Configure topology discovery, automatic and manual failover with pg_promote().
ProxySQL PostgreSQL Read/Write Splitting Setup (Part 2)
Configure ProxySQL 3.0.6 for PostgreSQL read/write splitting, health monitoring, and query routing. Tested on live VMs.
PostgreSQL HA Setup: Streaming Replication Guide (Part 1)
Build a 3-node PostgreSQL 17 streaming replication cluster on Multipass VMs. Step 1 of a ProxySQL + Orchestrator HA series.
How to Enable Checksums in PostgreSQL
A NetApp study found 400,000+ silent data corruptions across 1.5M drives. Learn how to enable PostgreSQL checksums at init, on existing clusters, and detect corruption before it reaches your backups.
How Do You Check Progress on PostgreSQL's Crash Recovery Process?
PostgreSQL 14's compactify_tuples optimization made crash recovery 2.4x faster. Learn 5 methods to monitor WAL replay progress, from pg_controldata to pg_stat_recovery_prefetch.
PostgreSQL Autovacuum Internals & Tuning Guide
At default settings, a 1 TB PostgreSQL table accumulates up to 200 GB of dead rows before autovacuum triggers. Learn how autovacuum's cost model works and how to tune it for production databases.
PostgreSQL Running Slow? A Step-by-Step Diagnostic Guide
Your PostgreSQL database is slow and you don't know why. This guide walks through a systematic diagnosis process — slow queries, EXPLAIN analysis, index auditing, and autovacuum.