- Home
- Database Proxy Software
- pgagroal
pgagroal
What it is
pgagroal is a free, self-hosted connection pool for PostgreSQL. It manages per-user and per-database connection limits, can prefill pools, remove idle connections, and validate connections. Administrators can enable or disable database access and choose graceful or fast shutdown. Remote management and command-line tools support runtime administration and user management.
For monitoring, pgagroal exports Prometheus metrics and provides a Grafana 12 dashboard. Authentication options include database-backed queries and a user vault for credentials. The project lists TLS v1.2 or later, with its TLS guide describing server-only and mutual client/server certificate authentication. When a PostgreSQL server can no longer accept writes, pgagroal can trigger an external failover workflow. It works with PostgreSQL-compliant drivers, including pgjdbc, Npgsql, and pq.
The repository identifies the license as BSD-3-Clause and lists Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD as tested platforms. The releases page lists packages through Fedora 42/43, Red Hat Enterprise Linux 10, and Rocky Linux 10. GitHub is the channel for questions, issue reports, feature requests, and code contributions.
For and against
For
- Sets per-user and per-database connection limits
- Exports Prometheus metrics
- Includes a Grafana 12 dashboard
- Supports server-only and mutual certificate authentication
Against
- Self-hosted deployment is required
- Supports PostgreSQL only
- Tested-platform list names specific operating systems
The verdict
pgagroal provides connection management, monitoring, and administration for self-hosted PostgreSQL deployments. Review its listed platform support and operational requirements before adopting it.
Who it suits
pgagroal suits teams running PostgreSQL that want a self-hosted connection pool and command-line or remote administration. It may also fit environments using Prometheus metrics and PostgreSQL-compliant drivers.
Plans and prices
pgagroal
BSD-3-Clause · self-hosted PostgreSQL connection pool
Read 7 Oct 2026 · github.com
On the record
- Administration
- It supports remote management and includes command-line tools for runtime administration and user management.pgagroal.github.io · read 7 Oct 2026
- Authentication
- It supports database-backed authentication queries and a user vault for credential management.pgagroal.github.io · read 7 Oct 2026
- Connection controls
- It supports per-user and per-database connection limits, pool prefill, idle connection removal, and connection validation.pgagroal.github.io · read 7 Oct 2026
- Current package availability
- The releases page lists packages through Fedora 42/43, Red Hat Enterprise Linux 10, and Rocky Linux 10.pgagroal.github.io · read 7 Oct 2026
- Drivers
- It works with PostgreSQL-compliant drivers, including pgjdbc, Npgsql, and pq.pgagroal.github.io · read 7 Oct 2026
- Failover
- It can trigger external failover workflows when a PostgreSQL server can no longer accept writes.pgagroal.github.io · read 7 Oct 2026
- License
- The project repository identifies its license as BSD-3-Clause.github.com · read 7 Oct 2026
- Monitoring
- It exports Prometheus metrics and provides a Grafana 12 dashboard.pgagroal.github.io · read 7 Oct 2026
- Operations
- It can enable or disable database access and supports graceful or fast shutdown.pgagroal.github.io · read 7 Oct 2026
- Purpose
- pgagroal is a high-performance connection pool for PostgreSQL.pgagroal.github.io · read 7 Oct 2026
- Support
- The project directs users to ask questions, raise issues, submit feature requests, and contribute code through GitHub.pgagroal.github.io · read 7 Oct 2026
- Supported systems
- The repository lists Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD as tested platforms.github.com · read 7 Oct 2026
- Transport security
- The project lists TLS v1.2+ support, and its TLS guide describes server-only and mutual client/server certificate authentication.pgagroal.github.io · read 7 Oct 2026
