Base
Hardened build
minimal ports, security patches applied at build time
PgCat PostgreSQL Connection Pooler with PostgreSQL 17 on Ubuntu 24.04 LTS
Azure
Databases
PgCat, a PostgreSQL connection pooler and proxy, fronting a bundled PostgreSQL database and ready to accept pooled connections the moment it boots.
Overview
PgCat is an open source PostgreSQL connection pooler and proxy written in Rust, in the tradition of PgBouncer but with load balancing, read/write splitting, sharding and automatic failover built in. It sits in front of PostgreSQL and multiplexes many short lived client connections onto a small pool of backend sessions, so connection heavy applications stay responsive when thousands of clients connect at once. Clients speak the normal PostgreSQL wire protocol to the pooler, which also exposes an administrative interface for live pool and traffic statistics.
This appliance bundles PgCat together with a ready to run PostgreSQL database on a single machine: PgCat listens for clients and transparently pools their connections onto the local database, giving you a self contained, pooled database endpoint for applications, serverless functions and other connection heavy workloads on infrastructure you control.
Why the cloudimg image
cloudimg ships PgCat and PostgreSQL preconfigured on a hardened, fully patched base, with the pooler running in transaction mode as the single connection endpoint and the database bound to the loopback interface behind it. It is secure by default with no shared credential in the image: no pooler or database password is ever baked in, and first boot generates a unique password for the database superuser and a separate unique password for the pooler admin console, mints a per instance TLS certificate, and only then starts the pooler, writing the credentials to a file only root can read so no two machines share a secret. Every image is proven by a real client connecting through the pooler to run a query and read live pool statistics before it ships. The operating system ships fully patched with unattended security updates enabled, and every image comes with a step by step deploy guide tested against the exact build and 24/7 cloudimg support.
Common uses
- Connection pooling for high concurrency applications
- A self contained pooled PostgreSQL endpoint for serverless and function backends
- Fronting an application database with transaction pooling and live pool statistics