PgDog
pgdog.dev
What it is
PgDog is a PostgreSQL connection pooler, load balancer, and database sharder designed to scale databases without application changes. It multiplexes many application connections across fewer PostgreSQL server connections and supports SET, LISTEN/NOTIFY, and advisory locks. Read queries can be distributed across replicas while writes go to the primary, with health checks and failover detection. Sharding keys guide query routing; queries without a key can run across databases in parallel. Cross-shard transactions use PostgreSQL prepared transactions and two-phase commit, with automatic rollback on errors. PgDog can copy data and stream row changes to another database without pausing query traffic. Deployment options include Kubernetes Helm, Docker, AWS ECS Terraform, pre-built binaries, and source. Releases include Linux arm64 and amd64, Apple Silicon Mac, and Debian packages; the macOS binary is unsigned. The project is free and open source under AGPL-3.0, and documentation says internal use does not require sharing source code. Enterprise support includes architecture reviews, a dedicated Slack channel, and an SLA promising a response within 15 minutes.
Spec sheet
- What it does
- PgDog is a PostgreSQL connection pooler, load balancer, and database sharder designed to scale databases without application changes.Read 29 Sep 2026 · docs.pgdog.dev
- Deployment
- PgDog can be deployed with Kubernetes Helm, Docker, AWS ECS Terraform, pre-built binaries, or from source.Read 29 Sep 2026 · docs.pgdog.dev
- Integrations
- The enterprise insights page lists Prometheus and OTEL exporters, plus Incident.io integration for alerts.Read 29 Sep 2026 · pgdog.dev
- Security
- The enterprise control plane page describes SSO for access protection, while installation documentation says user credentials can be encrypted at rest in supported environments such as Kubernetes or AWS Secrets Manager.Read 29 Sep 2026 · pgdog.dev
- License
- The project is free and open source under AGPL-3.0, and the documentation says internal use does not require sharing source code.Read 29 Sep 2026 · docs.pgdog.dev
- Headquarters
- San Francisco, California, United StatesRead 28 Sep 2026 · pgdog.dev
- Company
- The site identifies the company as PgDog, Inc.; the pages reviewed do not state its headquarters or founding year.Read 29 Sep 2026 · pgdog.dev
- Connection pooling
- It multiplexes thousands of application connections over a small number of PostgreSQL server connections and supports SET, LISTEN/NOTIFY, and advisory locks.Read 29 Sep 2026 · docs.pgdog.dev
- Enterprise support
- Enterprise support includes a dedicated Slack channel, architecture reviews, and an SLA promising a response within 15 minutes.Read 29 Sep 2026 · pgdog.dev
- Load balancing
- It distributes read queries across replicas and routes writes to the primary, with health checks and failover detection.Read 29 Sep 2026 · pgdog.dev
- Resharding
- PgDog can copy data and stream row changes to another database online without pausing query traffic.Read 29 Sep 2026 · docs.pgdog.dev
- Sharding
- PgDog routes queries using sharding keys and can execute queries without a key across databases in parallel.Read 29 Sep 2026 · pgdog.dev
- Supported binaries
- Pre-built releases are available for Linux arm64 and amd64, Apple Silicon Mac, and Debian packages; the macOS binary is unsigned.Read 29 Sep 2026 · docs.pgdog.dev
- Transactions
- The product page says cross-shard transactions use PostgreSQL prepared transactions and two-phase commit, with automatic rollback on errors.Read 29 Sep 2026 · pgdog.dev
Plans and prices
Strong points and limits
Strong points
- Free and open source under AGPL-3.0
- Routes reads to replicas and writes to primary
- Online data copying while query traffic continues
- Deployment options include Docker and Kubernetes Helm
Limits
- macOS binary is unsigned
- Supported database listed is PostgreSQL
Who it suits
PgDog suits teams running PostgreSQL that need connection pooling, read distribution, failover detection, or sharding. Its deployment options include self-hosted approaches, while Enterprise adds a control plane and support.
Verdict
PgDog combines pooling, routing, sharding, and online data movement for PostgreSQL. Teams should review deployment requirements and the unsigned macOS binary if considering that release.
Where Specifiction places it
- Database Proxy Software#12 of 317.7