./databases/pgbouncer, Lightweight connection pooler for PostgreSQL

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 1.22.1, Package name: pgbouncer-1.22.1, Maintainer: pkgsrc

Lightweight connection pooler for PostgreSQL that provides
the following features:

* Several levels of brutality when rotating connections.
* Low memory requirements.
* 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.


Required to run:
[net/libcares] [security/openssl] [devel/libevent]

Required to build:
[pkgtools/cwrappers]

Master sites:

Filesize: 661.476 KB

Version history: (Expand)


CVS history: (Expand)


   2024-04-11 08:55:27 by Thomas Klausner | Files touched by this commit (4) | Package updated
Log message:
pgbouncer: update to 1.22.1.

Based on PR 58137 by Patrick TJ McPhee; some cleanups while here.

Changes:

2019-08-27 - PgBouncer 1.11.0 - "Instinct for Greatness"
- Add support for SCRAM authentication and other password handling improvements
- Option to disable stats logging and other logging improvements
- Bug fixes and test suite improvements

2019-10-17 - PgBouncer 1.12.0 - "It's about learning and getting better"
- Support SO_REUSEPORT socket option
- Add support for using a pgbouncer-specific resolv.conf
- Fixes related to statistics reporting and password management
- Removes support for libevent 1.x and adds requiremetn to use pkg-config

2020-04-27 - PgBouncer 1.13.0 - "My favourite game"
- option to set tcp timeout
- TLS protocols now default to "secure" (TLS 1.1 and earlier turned \ 
off by default)
- various bug fixes

2020-06-11 - PgBouncer 1.14.0 - "La ritrovata magia"
- Add SCRAM authentication pass-through.
- New, minimal, sample config file

2020-11-19 - PgBouncer 1.15.0 - “Ich hab noch einen Koffer in Berlin”
- Improve authentication failure reporting.
- Don't log anything if client disconnects immediately.
- SHOW CONFIG now also shows the default values of the settings.
- A few bug fixes

2021-08-09 - PgBouncer 1.16.0 - Fended off a jaguar"
- Support hot reloading of TLS settings
- Add support for abstract Unix-domain sockets
- Increased the maximum lengths of passwords and usernames (996, 128)
- Tighter error handling in config parsing
- Query cancel handling has been fixed
- Mixed use of md5 and scram via hba has been fixed
- "FIXME: query end, but query_start == 0" has been fixed
- Fix reloading of default_pool_size, min_pool_size, and res_pool_size.
- reserved "pgbouncer" as a database name
- various cleanups and test improvements

2021-11-11 - PgBouncer 1.16.1 - "Test of depth against quiet efficiency"
- Fix to a potential man-in-the-middle vulnerability (CVE-2021-3935)

2022-03-23 - PgBouncer 1.17.0 - "A line has been drawn"
- support for round-robin database connection
- some errors not reported to unauthenticated clients
- increased maximum password length again
- openssl 3 support fixed
- dropped support for python 2 in test suite
- various other bug fixes

2022-12-12 - PgBouncer 1.18.0 - "No real mystery"
- Add application_name to SHOW CLIENTS/SERVERS/SOCKETS output
- Add information about cancel requests to SHOW CLIENTS/SERVERS/POOLS output
- Bug fixes, including an overflow bug and a race condition in query \ 
cancellation handling

2023-05-04 - PgBouncer 1.19.0 - "The old-fashioned, human-generated kind"
- Add support for peering between PgBouncer processes.
- Add the SHOW STATE command
- A few new configuration options
- New testing framework
- Various bug fixes

2023-05-31 - PgBouncer 1.19.1 - Sunny Spring
- Fix a few fatal errors
- Add missing files from the new testing framework

2023-07-20 - PgBouncer 1.20.0 - "A funny name goes here"
- Online restart option is now considered deprecated
- Introduce the track_extra_parameters which allows tracking of more parameters \ 
in transaction pooling mode.
- Forward SQLSTATE in authentication phase.
- Change default server_tls_sslmode to prefer
- Add support for the options startup parameter.
- Various bug fixes

2023-08-09 - PgBouncer 1.20.1 - "Optional options"
- Fixed regression related to options startup parameter

2023-10-16 - PgBouncer 1.21.0 - "The one with prepared statements"
- Add support for protocol-level named prepared statements
- Improve security of OpenSSL settings
- Various bug fixes

2024-01-31 - PgBouncer 1.22.0 - "DEALLOCATE ALL"
- Adds support for DEALLOCATE ALL and DISCARD ALL
- Support configuring auth_query per database
- Make fail fast logic handle all scenarios where no working connections to the \ 
database exist anymore and none can be established
- Some bug fixes

2024-03-04 - PgBouncer 1.22.1 - "It's summer in Bangalore"
- Fix issues caused by some clients using COPY FROM STDIN queries.
- Add missing tests to release tarball
- Multiple documentation improvements
   2023-10-25 00:11:51 by Thomas Klausner | Files touched by this commit (2298)
Log message:
*: bump for openssl 3
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2020-01-19 00:36:14 by Roland Illig | Files touched by this commit (3046)
Log message:
all: migrate several HOMEPAGEs to https

pkglint --only "https instead of http" -r -F

With manual adjustments afterwards since pkglint 19.4.4 fixed a few
indentations in unrelated lines.

This mainly affects projects hosted at SourceForce, as well as
freedesktop.org, CTAN and GNU.
   2020-01-18 22:51:16 by Jonathan Perkin | Files touched by this commit (1836)
Log message:
*: Recursive revision bump for openssl 1.1.1.
   2019-08-14 16:19:38 by Santhosh Raju | Files touched by this commit (4)
Log message:
databases/pgbouncer: Update to 1.10.0

Changes since 1.9.0

2019-07-01 - PgBouncer 1.10.0 - "Afraid of the World"

    Features
        Add support for enabling and disabling TLS 1.3. (TLS 1.3 was
        already supported, depending on the OpenSSL library, but now the
        configuration settings to pick the TLS protocol versions also
        support it.)
    Fixes
        Fix TLS 1.3 support. This was broken with OpenSSL 1.1.1 and
        1.1.1a (but not before or after).
        Fix a rare crash in SHOW FDS
        (https://github.com/pgbouncer/pgbouncer/issues/311/).
        Fix an issue that could lead to prolonged downtime if many cancel
        requests arrive
        (https://github.com/pgbouncer/pgbouncer/issues/329/).
        Avoid "unexpected response from login query" after a postgres
        reload
        (https://github.com/pgbouncer/pgbouncer/issues/220/).
        Fix idle_transaction_timeout calculation
        (https://github.com/pgbouncer/pgbouncer/issues/125/). The
        bug would lead to premature timeouts in specific situations.
    Cleanups
        Make various log and error messages more precise.
        Fix issues found by Coverity (none had a significant impact in
        practice).
        Improve and document all test scripts.
        Add additional SHOW commands to the documentation.
        Convert the documentation from rst to Markdown.
        Python scripts in the source tree are all compatible with Python 3
        now.
   2018-08-14 16:02:36 by Filip Hajny | Files touched by this commit (2)
Log message:
databases/pgbouncer: Update to 1.9.0.

Features

- RECONNECT command
- WAIT_CLOSE command
- Fast close - Disconnect a server in session pool mode immediately
  if it is in "close_needed" (reconnect) mode.
- Add close_needed column to SHOW SERVERS

Fixes

- Avoid double-free in parse_filename
- Avoid NULL pointer deref in parse_line

Cleanups

- Port mkauth.py to Python 3
- Improve signals documentation
- Improve quick start documentation
- Document SET command
- Correct list of required software
- Fix -Wimplicit-fallthrough warnings
- Add missing documentation for various SHOW fields
- Document reconnect behavior on reload and DNS change
- Document that KILL requires RESUME afterwards
- Clarify documentation of server_lifetime
- Typos and capitalization fixes in messages and docs
- Fix psql invocation in tests
- Various other test setup improvements