Home

The databases/pgbouncer port

pgbouncer-1.23.1 – lightweight connection pooler for PostgreSQL (cvsweb github mirror)

Description

PgBouncer is a lightweight connection pooler for PostgreSQL.

- Low memory requirements (2 kB per connection by default)

- It is not tied to one backend server; the destination databases
can reside on different hosts

- Supports online reconfiguration for most settings, and online
restart/upgrade without dropping client connections

- Several levels of brutality when rotating connections
WWW: https://www.pgbouncer.org/

Readme

+-----------------------------------------------------------------------
| Running ${PKGSTEM} on OpenBSD
+-----------------------------------------------------------------------

Post-installation steps
=======================
1. Carefully edit ${SYSCONFDIR}/pgbouncer/pgbouncer.ini and 
   ${SYSCONFDIR}/pgbouncer/userlist.txt to fit your needs.

2. Launch pgbouncer in foreground mode to see if everything 
   is ok:

   # install -d -o _pgbouncer /var/run/pgbouncer
   # pgbouncer -u _pgbouncer ${SYSCONFDIR}/pgbouncer/pgbouncer.ini

3. Launch pgbouncer with ${RCDIR}/pgbouncer start

Random hints
============
Check /var/log/pgbouncer/pgbouncer.log if something goes wrong.

Maintainer

Pierre-Emmanuel Andre

Categories

databases

Library dependencies

Build dependencies

Files

Search