pgagroal vs PgDog

pgagroal is a free, self-hosted PostgreSQL connection pool for Linux and macOS. It supports per-user and per-database connection limits, pool prefill, idle connection removal, and connection validation. Administrators can enable or disable database access and choose graceful or fast shutdown. Remote management and command-line tools handle runtime administration and user management. Monitoring exports Prometheus metrics and includes a Grafana 12 dashboard. Authentication can use database-backed queries or a user vault for credentials. If a PostgreSQL server can no longer accept writes, pgagroal can trigger an external failover workflow. The project lists TLS v1.2+ and describes both server-only and mutual certificate authentication. It works with PostgreSQL-compliant drivers including pgjdbc, Npgsql, and pq. Tested systems listed include Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD; releases list packages through Fedora 42/43, RHEL 10, and Rocky Linux 10. The repository identifies a BSD-3-Clause license. GitHub is used for questions, issues, feature requests, and code contributions.

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.