Sisyphus repository
Last update: 1 october 2023 | SRPMs: 18631 | Visits: 37369724
en ru br
ALT Linux repos
5.0: 1.2.3-alt1
4.1: 1.1.2-alt1

Group :: Databases
RPM: pgbouncer

 Main   Changelog   Spec   Patches   Sources   Download   Gear   Bugs and FR  Repocop 

Name: pgbouncer
Version: 1.1.2
Release:        alt1
Summary: Lightweight connection pooler for PostgreSQL
License: BSD
Group: Databases
Source: %name-%version.tgz
Source1:        pgbouncer.init
Source2:        pgbouncer.ini

BuildRequires: libevent-devel

%setup -q



%make DESTDIR=%buildroot install
%__install -p -m755 -D %SOURCE1 %buildroot%_initdir/pgbouncer
%__install -p -m755 -D %SOURCE2 %buildroot%_sysconfdir/pgbouncer.ini


Several levels of brutality when rotating connections:
Session pooling - Most polite method. When client connects, a server connection will be assigned to it for the whole duration it stays connected. When client disconnects, the server connection will be put back into pool.
Transaction pooling - Server connection is assigned to client only during a transaction. When PgBouncer notices that transaction is over, the server will be put back into pool. This is a hack as it breaks application expectations of backend connection. You can use it only when application cooperates with such usage by not using features that can break. See the table below for breaking features.
Statement pooling - Most aggressive method. This is transaction pooling with a twist - multi-statement transactions are disallowed. This is meant to enforce "autocommit" mode on client, mostly targeted for PL/Proxy.


Full changelog you can see here

design & coding: Vladimir Lettiev aka crux © 2004-2005, Andrew Avramenko aka liks © 2007-2008
current maintainer: Michael Shigorin