Feb 28, 2022 · Cloud Native

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

This guide explains how to combine a PostgreSQL Operator with Pgpool-II on Kubernetes to create a PostgreSQL cluster that supports query read‑load balancing and connection pooling, covering prerequisites, deployment steps, environment‑variable and ConfigMap configuration, backend settings, failover handling, password registration, streaming replication checks, SSL setup, and Prometheus monitoring.

Cloud NativeKubernetesPostgreSQL

0 likes · 13 min read

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

dbaplus Community

Oct 17, 2015 · Databases

Master PostgreSQL: From Origins to Hands‑On Labs and HA Strategies

This article presents a comprehensive overview of PostgreSQL, covering its history, architecture, core features, step‑by‑step lab exercises for database creation, CRUD operations, configuration tuning, performance monitoring, backup and recovery, Hot Standby replication, PGPOOL clustering, and a curated Q&A session addressing common DBA challenges.

BackupHAPostgreSQL

0 likes · 19 min read

Master PostgreSQL: From Origins to Hands‑On Labs and HA Strategies

pgpool

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

Master PostgreSQL: From Origins to Hands‑On Labs and HA Strategies