PgCat
5.8#16 in database proxy softwareFree planFree planLinuxSelf-hosted
Visit| Fact | PgCat | Supavisor |
|---|---|---|
| Authentication | MD5 auth passthrough can use auth_query so cleartext passwords are not required in the configuration file. | Client credentials can be verified using tenant user records or an authentication query. |
| Purpose | PgCat is a PostgreSQL pooler and proxy supporting sharding, load balancing, failover and mirroring. | Supavisor is a scalable, cloud-native Postgres connection pooler. |
PgCat may suit teams running PostgreSQL who want self-hosted connection pooling, query routing, or replica failover. Its transaction-mode limitations and experimental sharding and mirroring features matter when evaluating a deployment.
Supavisor suits teams operating PostgreSQL that need connection pooling across tenants or a single-tenant PgBouncer replacement. It is aimed at self-hosted deployments rather than serverless environments.