Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PgDog

pgdog.dev

  • Free plan
  • Windows
  • macOS
  • Linux
  • Self-hosted
7.3 Club score Visit pgdog.dev

What PgDog is

PgDog is software for managing PostgreSQL connections, read traffic, and sharded data without requiring application changes. Its connection pooler handles many application connections through a smaller set of database connections, while supporting SET, LISTEN/NOTIFY, and advisory locks. It sends reads to replicas and writes to the primary, with health checks and failover detection. For sharded setups, it can route queries by sharding key or run queries without a key across databases in parallel. Cross-shard transactions use prepared transactions and two-phase commit, with rollback on errors. PgDog can also move data and stream row changes to another database while queries continue. Deployment choices include Kubernetes Helm, Docker, AWS ECS Terraform, binaries, and source. The project is free and open source under AGPL-3.0; the listed free plan is free. Enterprise support includes architecture reviews, a dedicated Slack channel, and a 15-minute response SLA. Prometheus and OTEL exporters and Incident.io alerts are listed as integrations.

Who it suits

PgDog suits teams running PostgreSQL that need connection pooling, replica routing, or sharding. Its deployment options include self-hosted approaches, and enterprise support is available for organizations seeking an SLA.

Good to know, and what to watch

  • Multiplexes application connections over fewer database connections
  • Routes reads to replicas and writes to the primary
  • Runs keyless queries across databases in parallel
  • Moves data while query traffic continues
  • Free and open source under AGPL-3.0
  • macOS binary is unsigned

Enterprise

—

Open source

Free

Free plan

Getting started

  1. Open the PgDog website
  2. Choose a deployment route such as Kubernetes Helm, Docker, AWS ECS Terraform, a pre-built binary, or source
  3. Select a supported platform: Linux, macOS, Windows, or self-hosted
  4. Configure PostgreSQL connection pooling, routing, or sharding for your environment
  5. Use the free open-source plan or arrange enterprise support

Limits to check

The free Open source plan provides the AGPL-3.0 software. Enterprise features such as the production control plane, insights, dedicated Slack support, and SLA-backed support are offered separately.

The Club's review

Overview

PgDog is a PostgreSQL proxy that combines connection pooling, replica-aware query routing and database sharding for teams scaling PostgreSQL without changing application code. It is best suited to operators comfortable running infrastructure themselves, especially when one layer must handle both high connection counts and distributed data. Its open-source breadth is compelling, but PostgreSQL-only scope, AGPL-3.0 licensing and an unsigned macOS binary deserve careful consideration.

The project is free software under AGPL-3.0, and its documentation says internal use does not require sharing source code. PgDog, Inc. publishes the project; its site identifies San Francisco, California as headquarters.

For category context, see Database Proxy Software.

Key features

Connection pooling and routing

PgDog multiplexes thousands of application connections onto a smaller number of PostgreSQL server connections. Support for SET, LISTEN/NOTIFY and advisory locks means applications that rely on these session behaviors are not forced into a stripped-down pooling model. Read queries can be distributed across replicas while writes go to the primary. Health checks and failover detection make this useful for deployments where routing must react to database availability rather than remain static.

Sharding and transactions

Queries with a sharding key are routed to the relevant database, while queries without one can execute across databases in parallel. That gives teams a path to distribute data while retaining application compatibility, although cross-database work still brings operational complexity. PgDog describes cross-shard transactions using PostgreSQL prepared transactions and two-phase commit, with automatic rollback when errors occur.

Online resharding and operations

PgDog can copy data and stream row changes to another database while query traffic continues. Online movement is valuable when a shard layout must change without a maintenance pause. Enterprise insights add Prometheus and OTEL exporters and Incident.io alert integration, making the commercial tier more relevant to teams that need centralized observability.

Deployment and security

Deployment options include Kubernetes Helm, Docker, AWS ECS Terraform, pre-built binaries and source builds. Releases cover Linux arm64 and amd64, Apple Silicon Mac and Debian packages. The macOS binary is unsigned, so Mac administrators should expect an additional trust decision during installation. Supported environments such as Kubernetes or AWS Secrets Manager can encrypt user credentials at rest, while enterprise control-plane access includes SSO.

Pricing

Open source — free

This plan is free and open source under AGPL-3.0. It is the natural fit for teams willing to deploy and support a PostgreSQL proxy themselves, with no software charge stated. The trade-off is that production control-plane features, enterprise insights and dedicated support are not part of this plan.

Enterprise — custom pricing

Enterprise includes a production control plane, insights, a dedicated Slack channel, architecture reviews and SLA-backed support promising a response within 15 minutes. Choose it when operational assurance and centralized management matter more than keeping the entire operating burden in-house. The published material does not provide a price, so budget planning requires a direct commercial discussion.

Platforms

PgDog supports Linux, macOS, Windows and self-hosted deployments. The documented installation paths span Kubernetes, Docker, AWS ECS Terraform, binaries and source, giving infrastructure teams flexibility but leaving them responsible for deployment and ongoing operations.

Who it's for

PgDog fits PostgreSQL teams that need pooling, read/write splitting, automatic failover and sharding in one component, particularly when changing application code is undesirable. It is also a strong candidate for self-hosted environments that need online resharding or cross-shard transaction handling.

It is a weaker fit for organizations seeking a managed, multi-database service, a turnkey control plane at no cost, or a permissive license for redistribution. Teams standardizing on a database other than PostgreSQL should look elsewhere.

Pros and cons

Pros

  • Broad PostgreSQL scope: pooling, replica routing, failover detection and sharding are combined rather than deployed as separate layers.
  • Application-preserving scale path: sharding keys, parallel keyless queries and online data copying can expand capacity without pausing query traffic or rewriting applications.
  • Operational flexibility: self-hosted deployment works across containers, Kubernetes, AWS ECS and multiple CPU architectures.
  • Free core: the open-source plan has no stated software charge.

Cons

  • PostgreSQL only: it cannot serve teams whose primary database platform is MySQL or another engine.
  • AGPL-3.0 obligations: the license requires legal review for organizations distributing modified software, even though internal use is documented as not requiring source sharing.
  • Unsigned macOS binary: Mac deployments may require extra security approval.
  • Enterprise dependency for managed operations: control-plane, insights and SLA support require a custom-priced tier.

Alternatives

Choose MySQL instead when you need a freemium database platform with a Community Edition and replication or high-availability components across SQL and NoSQL applications.

Amazon RDS is the better direction for a paid managed database service with a Free Tier and trial terms.

Pick OceanBase Database when you want a distributed database with both Community and Enterprise editions.

SPQR is another free, open-source PostgreSQL sharding option, designed by Yandex.Cloud's Data Platform team.

Consider TurbineProxy for an Apache-2.0 open-source proxy with no per-query fees.

DBLE is a free, GPL-2.0 open-source option with enterprise support plans.

Choose Google Cloud SQL for a paid managed service with a Cloud SQL Enterprise plan at $0.04 a month and a 99.95% SLA.

Heimdall Database Proxy is an alternative with freemium Standard and Enterprise Plus editions.

Verdict

PgDog is a strong choice for PostgreSQL operators who want one free, self-hosted layer for pooling, replica routing, failover and sharding without application changes. Look elsewhere if you need a managed multi-database product, a permissive license, or enterprise control-plane support without custom pricing.

The verdict

PgDog combines connection pooling, load balancing, and sharding in one PostgreSQL-focused tool. Teams should consider its unsigned macOS binary and check enterprise pricing if they need the control plane or support.

Questions people ask

Is PgDog free?

Yes. The Open source plan is free at no cost and uses the AGPL-3.0 license.

Which databases does PgDog support?

PgDog supports PostgreSQL.

Where can PgDog run?

Platforms include Linux, macOS, Windows, and self-hosted environments. Deployment options include Kubernetes Helm, Docker, AWS ECS Terraform, pre-built binaries, and source.

Does PgDog provide automatic failover?

Yes. It performs health checks and detects failover while routing reads and writes.

What enterprise integrations are available?

The enterprise insights page lists Prometheus and OTEL exporters, plus Incident.io alert integration. The control plane describes SSO and encrypted-at-rest credentials in supported environments.

What the maker publishes

Company
The site identifies the company as PgDog, Inc.; the pages reviewed do not state its headquarters or founding year. source
Connection pooling
It multiplexes thousands of application connections over a small number of PostgreSQL server connections and supports SET, LISTEN/NOTIFY, and advisory locks. source
Deployment
PgDog can be deployed with Kubernetes Helm, Docker, AWS ECS Terraform, pre-built binaries, or from source. source
Enterprise support
Enterprise support includes a dedicated Slack channel, architecture reviews, and an SLA promising a response within 15 minutes. source
Headquarters
San Francisco, California, United States source
Integrations
The enterprise insights page lists Prometheus and OTEL exporters, plus Incident.io integration for alerts. source
License
The project is free and open source under AGPL-3.0, and the documentation says internal use does not require sharing source code. source
Load balancing
It distributes read queries across replicas and routes writes to the primary, with health checks and failover detection. source
Resharding
PgDog can copy data and stream row changes to another database online without pausing query traffic. source
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. source
Sharding
PgDog routes queries using sharding keys and can execute queries without a key across databases in parallel. source
Supported binaries
Pre-built releases are available for Linux arm64 and amd64, Apple Silicon Mac, and Debian packages; the macOS binary is unsigned. source
Transactions
The product page says cross-shard transactions use PostgreSQL prepared transactions and two-phase commit, with automatic rollback on errors. source
What it does
PgDog is a PostgreSQL connection pooler, load balancer, and database sharder designed to scale databases without application changes. source

Checked against the maker's pages on 29 Sept 2026.