PgDoorman

What PgDoorman is

PgDoorman is a free, open-source connection pooler for PostgreSQL, written in Rust and designed as a drop-in replacement for PgBouncer and Odyssey. It is self-hosted on Linux or macOS and supports PostgreSQL 10 and newer. Its pool coordinator applies per-database connection caps and can reclaim idle connections from pools with spare capacity. It caches anonymous Parse messages so pooled clients can reuse prepared backend state without application changes. With Patroni assistance, it can direct new backend connections to another live cluster member if the local PostgreSQL server goes away during a switchover. Monitoring includes a Prometheus metrics endpoint and an optional local diagnostic console covering pool, latency, error, query, log, CPU, and memory information. Authentication choices include MD5 or SCRAM passthrough, auth_query, PAM, JWT, Talos JWT, and pg_hba.conf rules. TLS can be set up for client and backend connections. The project reports three years of production use at Ozon with Go, .NET, Python, and Node.js workloads. It can be built from source, installed via distribution packages, or downloaded as a prebuilt binary; source builds require Rust 1.87 or newer. Docker is intended for development, CI, and demos rather than production.