macOS
Homebrewverified · 100%
brew install pgbouncerlocal Homebrew formula metadata
MacPortsverified · 94%
sudo port install pgbouncerMacPorts ports tree · databases/pgbouncer/Portfile · source: api.github.com
brew / rank 3297
Install pgbouncer with Homebrew, apk, apt, dnf, MacPorts, Nix, pacman
Lightweight connection pooler for PostgreSQL. Version 1.26.1 via Homebrew; verified 2026-10-14. Also installable with debian: sudo apt install pgbouncer.
install
Additional install commands
Linux
Alpine Linux apkverified · 92%
sudo apk add pgbouncerAlpine Linux edge package indexes · pgbouncer · source: dl-cdn.alpinelinux.org
Debian aptverified · 92%
sudo apt install pgbouncerDebian stable package indexes · pgbouncer · source: deb.debian.org
Fedora dnfverified · 92%
sudo dnf install pgbouncerFedora Rawhide package metadata · pgbouncer · source: dl.fedoraproject.org
Nixverified · 92%
nix profile install nixpkgs#pgbouncernixpkgs package indexes · pkgs/by-name/pg/pgbouncer/package.nix · source: api.github.com
Arch Linux pacmanverified · 92%
sudo pacman -S pgbouncerArch Linux sync databases · pgbouncer · source: geo.mirror.pkgbuild.com
overview
Package summary
Lightweight connection pooler for PostgreSQL
Project links
Commands and aliases
- mkauth.py
- pgbouncer
history
Project history and usage
PgBouncer is a lightweight PostgreSQL connection pooler that accepts client connections and reuses a smaller set of server connections through session, transaction, or statement pooling.
Project history
Marko Kreen announced PgBouncer 1.0 from Skype on March 13, 2007. The initial release emphasized low overhead, online administration, restart without dropping connections, and statement pooling for PL/Proxy workloads.
The project remained deliberately focused on PostgreSQL connection pooling. Session, transaction, and statement modes became its defining interface, while later releases improved protocol compatibility and reduced limitations in transaction-pooled applications.
Adoption history
PgBouncer became a standard PostgreSQL infrastructure component for applications that open more client connections than a database server should handle directly. Its lightweight process model and broad package-manager availability made it practical to deploy near applications, near PostgreSQL, or on both tiers.
Its continuing development has tracked production PostgreSQL protocol concerns, including authentication, TLS, observability, failover behavior, and support for protocol-level prepared statements in transaction and statement pooling modes.
How it is used
Operators create a pgbouncer.ini file describing target databases, listeners, authentication, pooling mode, and pool sizes; maintain an authentication file or auth_query; direct applications to PgBouncer's port; and inspect or control pools through its administrative database and SHOW commands.
Why package nerds care
PgBouncer is the canonical small PostgreSQL connection-pooling package: it changes the scaling characteristics of client connectivity without replacing PostgreSQL or requiring application-specific libraries. Its three pooling modes also expose an important operational trade-off between connection reuse and session semantics.
Timeline
- 2007: Skype announced PgBouncer 1.0.
- 2007: The 1.1 series followed with continued operational refinements.
- 2023: Version 1.21 added protocol-level prepared-statement tracking for transaction and statement pooling.
Related projects
- PgBouncer sits between PostgreSQL clients and PostgreSQL servers while speaking the PostgreSQL wire protocol on both sides. Standard clients such as psql can connect through it, and pgBadger can analyze its statistics logs.
Sources
security posture
Risk level: orange
formula declares a Homebrew service.
Risk classifier
orange risk · medium confidence · infrastructure
Why
- formula declares a Homebrew service
Signals
- metadata:service
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Formula metadata declares a service or daemon block.
- Homebrew bottle metadata is available for 5 platform targets.
- Installs with 2 runtime dependencies.
- Build metadata lists 2 build dependencies.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
local files
Configuration and credential file locations
These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.
Configuration files
Config paths the tool may read or write during local use.
- Unix
pgbouncer.ini
Credential files
Credential-bearing paths to review before unattended agent runs.
- Unix
userlist.txt
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
mkauth.py | cli | global executable | |
pgbouncer | cli | global executable |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-11-04
manager version1.26.1
manager updated2026-10-14
local dataok
upstreamnot checked
latest detectednot detected
- infoRelease/tag comparison is only available for GitHub repositories.https://www.pgbouncer.org/none confidence
install metadata
Package metadata
| Package key | brew:pgbouncer |
|---|---|
| Version | 1.26.1 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/pgbouncer |
| Homepage | https://www.pgbouncer.org/ |
| Repository | https://github.com/pgbouncer/pgbouncer |
| Upstream docs | https://www.pgbouncer.org/ |
| License | ISC |
| Source archive | https://www.pgbouncer.org/downloads/files/1.26.1/pgbouncer-1.26.1.tar.gz |
| Last updated | 2026-10-14T08:49:17Z |
| Pulse | updated |
| Dependencies | libevent, openssl@4 |
| Build dependencies | pandoc, pkgconf |
| Bottle | available (on arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | declared |
| Caveats | The config file: $HOMEBREW_PREFIX/etc/pgbouncer.ini is in the "ini" format and you will need to edit it for your particular setup. See: https://pgbouncer.github.io/config.html The auth_file option should point to the $HOMEBREW_PREFIX/etc/userlist.txt file which can be populated by the $HOMEBREW_CELLAR/pgbouncer/1.26.1/bin/mkauth.py script. |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | pgbouncer |
| Version Scheme | 0 |
| Revision | 0 |
| Head Version | HEAD |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
Debian apt95%
pgbouncer 1.24.1-1+deb13u2
lightweight connection pooler for PostgreSQL
sudo apt install pgbouncer- Section: database
- Architecture: amd64
- 7 dependencies
- 2 optional deps
- normalized package name match
- Matched by: Pgbouncer
Nix95%
pgbouncer
nix profile install nixpkgs#pgbouncer- normalized package name match
- Matched by: Pgbouncer
Ubuntu apt95%
pgbouncer 1.22.0-1build4
lightweight connection pooler for PostgreSQL
sudo apt install pgbouncer- Section: universe/misc
- Architecture: amd64
- 7 dependencies
- 2 optional deps
- normalized package name match
- Matched by: Pgbouncer
apk95%
pgbouncer 1.25.2-r0
Lightweight connection pooler for PostgreSQL
sudo apk add pgbouncer- License: ISC
- Architecture: x86_64
- Source Package: pgbouncer
- 1 dependencies
- 1 provides
- normalized package name match
- Matched by: Pgbouncer
apk95%
pgbouncer-doc 1.25.2-r0
Lightweight connection pooler for PostgreSQL (documentation)
sudo apk add pgbouncer-doc- License: ISC
- Architecture: x86_64
- Source Package: pgbouncer
- normalized package name match
- Matched by: Pgbouncer
apk95%
pgbouncer-openrc 1.25.2-r0
Lightweight connection pooler for PostgreSQL (OpenRC init scripts)
sudo apk add pgbouncer-openrc- License: ISC
- Architecture: x86_64
- Source Package: pgbouncer
- normalized package name match
- Matched by: Pgbouncer
dnf95%
pgbouncer 1.25.2-4.fc46
Lightweight connection pooler for PostgreSQL
sudo dnf install pgbouncer- License: ISC and BSD-2-Clause
- Category: Unspecified
- Architecture: x86_64
- Source Package: pgbouncer
- 16 dependencies
- 4 provides
- normalized package name match
- Matched by: Pgbouncer
pacman95%
pgbouncer 1.25.2-1
Lightweight connection pooler for PostgreSQL
sudo pacman -S pgbouncer- License: ISC
- Architecture: x86_64
- 8 dependencies
- normalized package name match
- Matched by: Pgbouncer
MacPorts95%
pgbouncer
sudo port install pgbouncer- normalized package name match
- Matched by: Pgbouncer
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- cross-ecosystem install command graph
- curated configuration and credential file locations
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment
- pkg.so package database
- pkgdb category and tag curation