PgCat review
A focused, free PostgreSQL proxy for pooling, routing, failover, and sharding.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
PgCat is an open-source PostgreSQL connection pooler and proxy for teams running PostgreSQL applications and clusters. It multiplexes client connections into reusable server connections and supports both transaction and session pooling. The product is aimed at organizations that want to manage PostgreSQL traffic within their own Linux-based infrastructure, including deployments using containers, Kubernetes, systemd, or a source build.
PgCat’s central advantage is breadth within the PostgreSQL proxy role. It can balance read queries across replicas and the primary server, route queries between primary and replica systems, and reroute traffic around unhealthy servers through automatic failover. Database sharding extends its scope beyond connection reuse, while administrative statistics databases and a Prometheus metrics endpoint provide operational visibility. TLS and MD5/SCRAM authentication address connection security, and live configuration reloading can simplify changes to a running deployment. The software is presented as free, open-source software under the MIT license, making it suitable for teams seeking PostgreSQL pooling without a paid software tier.
The trade-off is a focused deployment model. PgCat supports PostgreSQL and is designed for self-hosted Linux environments, so it suits teams that control their infrastructure and want direct responsibility for deployment and operations. It is less appropriate for organizations seeking a managed database proxy, broad multi-database coverage, or a hosted service. Choose PgCat when PostgreSQL pooling, query routing, failover, sharding, and infrastructure control are priorities; choose an alternative when managed operations or support for database systems beyond PostgreSQL matter more.
PgCat pros and cons
- Where it wins
- Free, MIT-licensed PostgreSQL pooling and proxying
- Combines routing, load balancing, failover, and sharding
- Supports TLS, authentication, metrics, and live reloads
- Where it doesn't
- Focused on PostgreSQL rather than multiple database engines
- Requires self-hosted Linux deployment
- No built-in AI features
PgCat fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update