PgDoorman

Free#16 of 31 in Database Proxy Software

PgDoorman: A focused PostgreSQL pooler for teams that need Patroni-aware fallback and routing. Ranked #16 of 31 in Database Proxy Software by our editors (7.6/10); pricing: Open source; best for postgreSQL pooling with Patroni.

7.6/10★★★★☆Editor score

Visit PgDoorman

At a glance

• Editor score
  7.6 / 10
• Pricing
  Open source
• Best for
  PostgreSQL pooling with Patroni
• Paid from
  Free
• Deployment model
  Self-hosted
• Facts checked
  20 Sep 2026

• Where it wins

  • Session and transaction pooling with shared worker pools
  • Patroni-assisted fallback and role-based backend routing
  • Prometheus metrics, admin commands, and automatic configuration

• Where it doesn't

  • Routing is role-based rather than query-based
  • Self-hosted deployment requires operational ownership
  • Focused on PostgreSQL 10 and newer

Our verdict on PgDoorman

PgDoorman is a self-hosted PostgreSQL connection pooler written in Rust, designed for teams operating PostgreSQL workloads on Linux or macOS. It sits between applications and PostgreSQL, reusing backend connections through session or transaction pooling. The project supports PostgreSQL 10 and newer, YAML or TOML configuration, and applications built with Go, .NET, Python, and Node.js. Its open-source model suits teams that want to run and manage the pooler themselves rather than adopt a hosted service.

Its strongest fit is PostgreSQL infrastructure using Patroni. PgDoorman provides Patroni-assisted backend fallback and role-based backend routing through patroni_proxy, alongside automatic configuration generation from PostgreSQL. Database-level connection caps with priority eviction add control over connection pressure, while a multithreaded shared pool spans worker threads. Prepared-statement and plan caching are also included. These capabilities make it a practical choice for teams prioritizing connection reuse, failover behavior, and operational control around a Patroni-backed PostgreSQL environment.

Operations are supported through a Prometheus metrics endpoint and an administrative console with operational commands. The published feature set is focused: PgDoorman offers load balancing and automatic failover, but its routing is role-based rather than query-based. It is therefore better suited to teams seeking a PostgreSQL-specific pooler with Patroni integration than to organizations needing broader database coverage or query-aware routing. Teams that want self-hosted control and can operate Linux or macOS infrastructure should consider it; teams requiring query-level routing should look for a different fit.

Questions about PgDoorman

What does PgDoorman run on? Linux and macOS. It runs self-hosted.

What does PgDoorman integrate with? 2 integrations: Patroni and Prometheus.

Who is PgDoorman built for? Small businesses, mid-market companies and enterprises (our editorial estimate).

Your product? Our editors can test PgDoorman in depth and publish a review, labelled as paid · from $149/mo →

PgDoorman pricing

PgDoorman fact sheet

PgDoorman integrations

PgDoorman lists 2 integrations on its own site.

• Patroni
• Prometheus

Alternatives to PgDoorman

• Heimdall Database ProxyA broad database proxy with pooling, routing, analytics, security, and failover.9.4
• ProxySQLA free, open-source proxy for routing, pooling, balancing, and managing database traffic.9.2
• ShardingSphere-ProxyA self-hosted proxy for routing, scaling, and high availability across four database protocols.9.0

See all PgDoorman alternatives →

Used PgDoorman? Be the first to review it

The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used PgDoorman for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.

Write a reviewTwo minutes · verified accounts only · read by an editor before it appears

Website

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Your rating

5 stars★4 stars★3 stars★2 stars★1 star★

Title

Your review

0 characters · at least 80, up to 3,000

Pros (optional · one per line)

Cons (optional · one per line)

Your name (shown with your review)

Role (optional)

Company (optional)

How long have you used it?Prefer not to sayLess than a month1–6 months6–12 months1–2 years2+ years

I've used PgDoorman myself and this is my honest opinion — nobody paid or asked me to write it.

Send my reviewPosted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

Reviewed by iTechGuides Editors · Editorial team · Updated Nov 2026

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 14 Nov 2026 · How we research and update