PgCat
github.com
- Free plan
- Linux
- Self-hosted
What PgCat is
PgCat is a free, open-source PostgreSQL pooler and proxy for self-hosted Linux deployments. Its stable pooling options include transaction and session pooling. Read queries can be distributed across replicas and the primary, while health checks detect broken replicas and redirect queries to servers that remain available. PgCat uses Tokio’s asynchronous runtime and a multithreaded design for multicore machines. Operators can inspect pool statistics through the pgcat and pgbouncer admin databases or a Prometheus HTTP endpoint. Client and server connections can use SSL/TLS, and authentication supports MD5 and SCRAM-SHA-256. MD5 passthrough can use auth_query so cleartext passwords are not needed in the configuration file. Docker deployment is documented, and the project publishes a container image. Sharding syntax, automatic sharding, comment parsing, and mirroring are experimental. Transaction mode is enabled by default and does not support prepared statements, SET, or advisory locks. PgCat is licensed under MIT.
Who it suits
PgCat suits teams running PostgreSQL on self-hosted Linux that need connection pooling, query routing, or read balancing. Operators should consider its experimental sharding and mirroring features and transaction-mode limits.
Good to know, and what to watch
- Stable transaction and session pooling.
- Health checks reroute queries from broken replicas.
- Statistics are available through admin databases and Prometheus.
- SSL/TLS and MD5 or SCRAM-SHA-256 authentication are supported.
- Free and open source under the MIT license.
- Sharding and mirroring features are experimental.
- Transaction mode does not support prepared statements.
- Transaction mode does not support SET or advisory locks.
Plans
Every plan and priceOpen source
Free plan
The verdict
PgCat offers PostgreSQL pooling, routing, monitoring, and failover in a free, self-hosted package. Its experimental features and transaction-mode restrictions matter when deciding how to deploy it.
What the maker publishes
- Authentication
- MD5 auth passthrough can use auth_query so cleartext passwords are not required in the configuration file. source
- Deployment
- The project documents Docker deployment and publishes ghcr.io/postgresml/pgcat:latest. source
- Failover
- Broken replicas are detected with health checks and queries are rerouted to remaining servers. source
- License
- PgCat is free and open source under the MIT license. source
- Maker
- PostgresML was founded in 2022 by engineers who built Instacart’s machine learning platform. source
- Mirroring
- Mirroring is an experimental feature that sends queries to multiple databases for testing or replica prewarning. source
- Monitoring
- Pooler statistics are available through the pgcat and pgbouncer admin databases and through a Prometheus HTTP endpoint. source
- Pooling
- Transaction pooling and session pooling are stable features. source
- Production status
- The project says PgCat is stable and used in production to serve hundreds of thousands of queries per second. source
- Purpose
- PgCat is a PostgreSQL pooler and proxy supporting sharding, load balancing, failover and mirroring. source
- Read balancing
- Read queries can be automatically load balanced between replicas and the primary. source
- Runtime
- PgCat uses Tokio’s asynchronous runtime and a multithreaded design for multicore machines. source
- Security
- Clients and PostgreSQL servers can use SSL/TLS, and authentication supports MD5 and SCRAM-SHA-256 connections. source
- Sharding
- Extended SQL syntax, comment parsing and automatic sharding are experimental features. source
- Transaction-mode limit
- Transaction mode is enabled by default and does not support prepared statements, SET or advisory locks. source
Checked against the maker's pages on 1 Oct 2026.