pgagroal
pgagroal is a free, self-hosted connection pool for PostgreSQL, designed to manage application connections to the database.
What pgagroal is
pgagroal is a free, self-hosted connection pool for PostgreSQL, designed to manage application connections to the database. It supports per-user and per-database limits, pre-filling pools, removing idle connections, and validating connections. Administrators can enable or disable database access and choose graceful or fast shutdown. For operations, it provides remote management and command-line tools for runtime and user administration. Monitoring includes Prometheus metrics and a Grafana 12 dashboard. Authentication options include database-backed queries and a credential vault. The project lists TLS v1.2 or later, with server-only and mutual client/server certificate authentication described in its guide. It can trigger external failover workflows if a PostgreSQL server cannot accept writes, and works with PostgreSQL-compliant drivers such as pgjdbc, Npgsql, and pq. The repository identifies the license as BSD-3-Clause. Listed tested systems include Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD; the releases page lists packages through Fedora 42/43, RHEL 10, and Rocky Linux 10.
Good
- Per-user and per-database connection limits
- Prometheus metrics and Grafana dashboard
- Remote management and command-line administration
- BSD-3-Clause license
Watch out
- Designed for PostgreSQL
- Requires a self-hosted deployment
- Listed tested systems vary from listed package availability
Who it suits
pgagroal suits teams running PostgreSQL who want to manage connections in a self-hosted deployment. It also provides monitoring and remote or command-line administration options.
Verdict
pgagroal combines connection management with administration, monitoring, and authentication features for PostgreSQL. Its self-hosted model and listed system support are key considerations when evaluating it.
Plans and prices
From pgagroal's own pricing page, checked 7 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| pgagroal | Free | BSD-3-Clause · self-hosted PostgreSQL connection pool |
The facts
Each one read from pgagroal's own pages, with the date it was checked.
What it does
- Administration
- It supports remote management and includes command-line tools for runtime administration and user management.checked 7 Oct 2026
- Authentication
- It supports database-backed authentication queries and a user vault for credential management.checked 7 Oct 2026
- Connection controls
- It supports per-user and per-database connection limits, pool prefill, idle connection removal, and connection validation.checked 7 Oct 2026
- Current package availability
- The releases page lists packages through Fedora 42/43, Red Hat Enterprise Linux 10, and Rocky Linux 10.checked 7 Oct 2026
- Drivers
- It works with PostgreSQL-compliant drivers, including pgjdbc, Npgsql, and pq.checked 7 Oct 2026
- Failover
- It can trigger external failover workflows when a PostgreSQL server can no longer accept writes.checked 7 Oct 2026
- License
- The project repository identifies its license as BSD-3-Clause.checked 7 Oct 2026
- Monitoring
- It exports Prometheus metrics and provides a Grafana 12 dashboard.checked 7 Oct 2026
- Operations
- It can enable or disable database access and supports graceful or fast shutdown.checked 7 Oct 2026
- Purpose
- pgagroal is a high-performance connection pool for PostgreSQL.checked 7 Oct 2026
- Support
- The project directs users to ask questions, raise issues, submit feature requests, and contribute code through GitHub.checked 7 Oct 2026
- Supported systems
- The repository lists Fedora 38+, RHEL 9.x, Rocky Linux 9.x, FreeBSD, and OpenBSD as tested platforms.checked 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.checked 7 Oct 2026
Alternatives to pgagroal
- 1
OceanBase Database
Free planOpen sourceWebAPILinuxmacOS8.2$2.38 usage-based - 2

MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 3
Supavisor
Free planOpen sourceAPILinuxSelf-hosted7.6From $25 a month - 4
Avidemux
Free planOpen sourceWebLinuxmacOSWindows7.3Free plan - 5
TiCDC
Free planOpen sourceAPILinuxmacOSSelf-hosted7.2Free plan - 6

Amazon RDS
Free planWebAPISelf-hosted7.1Free plan
