This guide explains what a sharded PostgreSQL cluster is, how StackGres implements it with Citus and Patroni, and provides step‑by‑step YAML manifests and scripts to create both a basic and a custom production‑grade high‑availability sharded cluster on Kubernetes.
This guide walks through identifying master and replica pods, performing graceful switchover, triggering automated failover, and reinitializing replicas in a StackGres 1.6 cluster using kubectl and patronictl commands, with practical notes and safety warnings.
This guide explains how StackGres 1.6 uses custom Kubernetes CRDs—SGPostgresConfig, SGInstanceProfile, and SGPoolingConfig—to define PostgreSQL parameters, instance sizing, and PgBouncer connection‑pool settings, and shows how to apply, reload, disable, and inspect these configurations with kubectl.
StackGres 1.6 is a full‑stack, production‑grade PostgreSQL distribution for Kubernetes that bundles a curated set of components—including Patroni, WAL‑G, PgBouncer, Envoy, and monitoring tools—into a single declarative deployment unit with multiple access methods, sidecar architecture, and built‑in high‑availability, backup, and observability features.
