PgDog: PostgreSQL Connection Pooler, Load Balancer, and Database Sharder
By
levkk
3mo ago· 13 min readenCode
100/100
Golden Brown
Bagelometer↗
Crackling crust, pillowy middle. The kind of bagel that earns a second cup of coffee.
Score100Typehow-toSentimentneutral
Summary
PgDog is a PostgreSQL proxy tool written in Rust that provides connection pooling, load balancing, and database sharding capabilities. It's designed to scale PostgreSQL databases by managing thousands of connections on commodity hardware. The article provides documentation links, quick start guides for Kubernetes (including Helm chart installation) and AWS deployment options (EKS with Helm or Terraform module for RDS).
Key quotes
· 5 pulledPgDog is a proxy for scaling PostgreSQL. It supports connection pooling, load balancing queries and sharding entire databases.
Written in Rust, PgDog is fast, secure and can manage thousands of connections on commodity hardware.
Helm chart is here. To install it, run:
If you're using AWS RDS, you can deploy PgDog using one of two supported methods:
Terraform module to deploy PgDog
PostgreSQL connection pooler, load balancer and database sharder. - pgdogdev/pgdog
