Blog
"Everything is a process until you leave this world."
PostgreSQL High Availability with Patroni + pgpool-II — A Complete Guide
A complete, decision-ready guide to a production 3-node PostgreSQL 16 HA cluster — Patroni owns the data plane, pgpool-II owns the access plane, with 5/5 validated power-loss fa...
Testing High Availability PostgreSQL: From Manual Failover to Patroni + etcd + pgpool-II — A Journey of Real Faults, Honest Gaps, and Three Bugs We Didn't Expect
An honest engineering journey testing Patroni + etcd + pgpool-II against the exact fears that kept production on manual failover — false positives, data loss, and the real bugs ...
Crunchy Data PostgreSQL Operator (PGO) — Production Operations Guide
A comprehensive production operations guide for Crunchy Data's PostgreSQL Operator (PGO) on Kubernetes. Covers deploying PostgresCluster resources, Patroni configuration, pgBack...
A Secure Kubernetes Multi-Master Cluster Setup Guide
A comprehensive, secure, step-by-step manual guide for setting up a production-grade multi-master Kubernetes cluster. Covers architecture planning, OS prerequisites, cluster ini...
Setting Up Highly Available PostgreSQL Cluster with Patroni, etcd, HAProxy, and Keepalived
1. Overview 2. Architecture 3. Prerequisites 4. Initial Setup - Hostname Configuration - Package Installation
PostgreSQL 17 + Pgpool-II HA Cluster — Configuration Guide
A comprehensive step-by-step guide to deploying a highly available PostgreSQL 17 cluster with Pgpool-II 4.5, including streaming replication, watchdog, virtual IP failover, and ...
ETL Server Setup to transfer data from Production to a Example. Data Warehouse Guide: Apache Airflow & PipelineWise
This guide provides clear, step-by-step instructions for setting up Apache Airflow and PipelineWise to manage and orchestrate ETL (Extract, Transform, Load) pipelines. It is des...
Setting Up Streaming Standby for PGO Crunchy PostgreSQL Cluster
- Introduction - Prerequisites - Step 1: Prepare TLS Certificates - Step 2: Create Kubernetes Secrets - Step 3: Configure Primary Cluster
Setting Up RSync in PGO Crunchy Database to Copy pgBackRest Backup Files to a New replica_ABC and install PostgreSQL, pgBackRest and Restore backups on that replica_ABC
This documentation provides detailed steps on how to set up RSync in Kubernetes (K8s) to copy pgBackRest backup files to a new replicaABC. It will aslo help you set up PostgreSQ...