PgBouncer Free and lightweight connection pooler for PostgreSQL
Download

PgBouncer Ranking & Summary

PgBouncer Tags

connection PostgreSQL connection pooler PostgreSQL pooler rotate connection pooler

PgBouncer Description

Free and lightweight connection pooler for PostgreSQL PgBouncer is an open source and free PostgreSQL connection pooler. Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will manage to connect to the server, or to reuse one of its existing connections.The aim of PgBouncer is to lower the performance impact of opening new connections to PostgreSQL. Here are some key features of "PgBouncer": · Several levels of brutality when rotating connections · Low memory requirements (2k per connection by default). This is due to the fact that PgBouncer does not need to see full packet at once. · It is not tied to one backend server, the destination databases can reside on different hosts. · Supports online reconfiguration for most of the settings. · Supports online restart/upgrade without dropping client connections. · Supports protocol V3 only, so backend version must be >= 7.4. What's New in This Release: · Fix problem with sbuf_loopcnt which could make connections hang. · If query or result length is nearby of multiple of (pktlen*sbuf_loopcnt) · , it could stay waiting for more data which will not · appear. · Make database reconfigure immediate. Currently old connections · could be reused after SIGHUP. · Fix SHOW DATABASES which was broken due to column addition. · Console access was disabled when "auth_mode=any" as pgbouncer dropped username. · Fix: if "auth_mode=any", allow any user to console as admin. · Fix bad CUSTOM_ALIGN macro. Luckily it's unused if OS already · defines ALIGN macro thus seems the bug has not happened in wild. · win32: call WSAStartup() always, not only in daemon mode · as config parsing wants to resolve hosts. · win32: put quotes around config filename in service · cmdline to allow spaces in paths. Executable path · does not seem to need it due to some win32 magic. · Add STATS to SHOW HELP text. · doc/usage.txt: the time units in console results are in · microseconds, not milliseconds.

PgBouncer Related Software