head 1.4; access; symbols pkgsrc-2026Q1:1.4.0.16 pkgsrc-2026Q1-base:1.4 pkgsrc-2025Q4:1.4.0.14 pkgsrc-2025Q4-base:1.4 pkgsrc-2025Q3:1.4.0.12 pkgsrc-2025Q3-base:1.4 pkgsrc-2025Q2:1.4.0.10 pkgsrc-2025Q2-base:1.4 pkgsrc-2025Q1:1.4.0.8 pkgsrc-2025Q1-base:1.4 pkgsrc-2024Q4:1.4.0.6 pkgsrc-2024Q4-base:1.4 pkgsrc-2024Q3:1.4.0.4 pkgsrc-2024Q3-base:1.4 pkgsrc-2024Q2:1.4.0.2 pkgsrc-2024Q2-base:1.4 pkgsrc-2024Q1:1.3.0.38 pkgsrc-2024Q1-base:1.3 pkgsrc-2023Q4:1.3.0.36 pkgsrc-2023Q4-base:1.3 pkgsrc-2023Q3:1.3.0.34 pkgsrc-2023Q3-base:1.3 pkgsrc-2023Q2:1.3.0.32 pkgsrc-2023Q2-base:1.3 pkgsrc-2023Q1:1.3.0.30 pkgsrc-2023Q1-base:1.3 pkgsrc-2022Q4:1.3.0.28 pkgsrc-2022Q4-base:1.3 pkgsrc-2022Q3:1.3.0.26 pkgsrc-2022Q3-base:1.3 pkgsrc-2022Q2:1.3.0.24 pkgsrc-2022Q2-base:1.3 pkgsrc-2022Q1:1.3.0.22 pkgsrc-2022Q1-base:1.3 pkgsrc-2021Q4:1.3.0.20 pkgsrc-2021Q4-base:1.3 pkgsrc-2021Q3:1.3.0.18 pkgsrc-2021Q3-base:1.3 pkgsrc-2021Q2:1.3.0.16 pkgsrc-2021Q2-base:1.3 pkgsrc-2021Q1:1.3.0.14 pkgsrc-2021Q1-base:1.3 pkgsrc-2020Q4:1.3.0.12 pkgsrc-2020Q4-base:1.3 pkgsrc-2020Q3:1.3.0.10 pkgsrc-2020Q3-base:1.3 pkgsrc-2020Q2:1.3.0.8 pkgsrc-2020Q2-base:1.3 pkgsrc-2020Q1:1.3.0.4 pkgsrc-2020Q1-base:1.3 pkgsrc-2019Q4:1.3.0.6 pkgsrc-2019Q4-base:1.3 pkgsrc-2019Q3:1.3.0.2 pkgsrc-2019Q3-base:1.3 pkgsrc-2019Q2:1.2.0.30 pkgsrc-2019Q2-base:1.2 pkgsrc-2019Q1:1.2.0.28 pkgsrc-2019Q1-base:1.2 pkgsrc-2018Q4:1.2.0.26 pkgsrc-2018Q4-base:1.2 pkgsrc-2018Q3:1.2.0.24 pkgsrc-2018Q3-base:1.2 pkgsrc-2018Q2:1.2.0.22 pkgsrc-2018Q2-base:1.2 pkgsrc-2018Q1:1.2.0.20 pkgsrc-2018Q1-base:1.2 pkgsrc-2017Q4:1.2.0.18 pkgsrc-2017Q4-base:1.2 pkgsrc-2017Q3:1.2.0.16 pkgsrc-2017Q3-base:1.2 pkgsrc-2017Q2:1.2.0.12 pkgsrc-2017Q2-base:1.2 pkgsrc-2017Q1:1.2.0.10 pkgsrc-2017Q1-base:1.2 pkgsrc-2016Q4:1.2.0.8 pkgsrc-2016Q4-base:1.2 pkgsrc-2016Q3:1.2.0.6 pkgsrc-2016Q3-base:1.2 pkgsrc-2016Q2:1.2.0.4 pkgsrc-2016Q2-base:1.2 pkgsrc-2016Q1:1.2.0.2 pkgsrc-2016Q1-base:1.2 pkgsrc-2015Q4:1.1.0.2 pkgsrc-2015Q4-base:1.1; locks; strict; comment @# @; 1.4 date 2024.04.11.06.55.27; author wiz; state Exp; branches; next 1.3; commitid X1Auzoj1QrV15H5F; 1.3 date 2019.08.14.14.19.38; author fox; state Exp; branches; next 1.2; commitid aeNpPddmcrCsf0zB; 1.2 date 2016.03.15.11.29.35; author fhajny; state Exp; branches; next 1.1; commitid 2eiMAcIOb678oJYy; 1.1 date 2015.10.23.16.40.38; author fhajny; state Exp; branches; next ; commitid O8qWeb4hV5wJJfGy; desc @@ 1.4 log @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 @ text @$NetBSD$ Install example files in pkgsrc default examples directory. --- Makefile.orig 2023-05-04 07:53:35.000000000 -0400 +++ Makefile 2023-05-09 22:50:23.495150905 -0400 @@@@ -67,12 +67,14 @@@@ # docs to install as-is dist_doc_DATA = README.md NEWS.md \ - etc/pgbouncer-minimal.ini \ - etc/pgbouncer.ini \ etc/pgbouncer.service \ - etc/pgbouncer.socket \ + etc/pgbouncer.socket + +dist_sysconf_DATA = etc/pgbouncer-minimal.ini \ + etc/pgbouncer.ini \ etc/userlist.txt + DISTCLEANFILES = config.mak config.status lib/usual/config.h config.log DIST_SUBDIRS = doc test @ 1.3 log @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. @ text @d1 1 a1 1 $NetBSD: patch-Makefile,v 1.2 2016/03/15 11:29:35 fhajny Exp $ d3 1 a3 1 Install sample config files as... config files. d5 3 a7 4 --- Makefile.orig 2019-07-01 04:00:00.000000000 -0400 +++ Makefile @@@@ -51,7 +51,8 @@@@ pgbouncer_EMBED_LIBUSUAL = 1 d10 10 a19 3 -dist_doc_DATA = README.md NEWS.md etc/pgbouncer.ini etc/userlist.txt +dist_doc_DATA = README.md NEWS.md +dist_sysconf_DATA = etc/pgbouncer.ini etc/userlist.txt d21 1 d24 1 @ 1.2 log @Update databases/pgbouncer to 1.7.2. Set up a separate user, previous PGUSER/PGGROUP integration didn't make sense. 2016-02-26 - PgBouncer 1.7.2 - "Finally Airborne" - Fix crash on stale pidfile removal. Problem introduced in 1.7.1. - Disable cleanup - it breaks takeover and is not useful for production loads. Problem introduced in 1.7.1. - After takeover, wait until pidfile is gone before booting. Slow shutdown due to memory cleanup exposed existing race. (#113) - Make build reproducible by dropping DBGVER handling. (#112) - Antimake: Sort file list from $(wildcard), newer gmake does not sort it anymore. (#111) - Show libssl version in log. - deb: Turn on full hardening. 2016-02-18 - PgBouncer 1.7.1 - "Forward To Five Friends Or Else" - WARNING: Since version 1.7, server_reset_query is not executed when database is in transaction-pooling mode. Seems this was not highlighted enough in 1.7 announcement. If your apps depend on that happening, use server_reset_query_always to restore previous behaviour. - TLS: Rename sslmode "disabled" to "disable" as that is what PostgreSQL uses. - TLS: client_tls_sslmode=verify-ca/-full now reject connections without client certificate. (#104) - TLS: client_tls_sslmode=allow/require do validate client certificate if sent. Previously they left cert validation unconfigured so connections with client cert failed. (#105) - Fix memleak when freeing database. - Fix potential memleak in tls_handshake(). - Fix EOF handling in tls_handshake(). - Fix too small memset in asn1_time_parse compat. - Fix non-TLS (--without-openssl) build. (#101) - Fix various issues with Windows build. (#100) - TLS: Use SSL_MODE_RELEASE_BUFFERS to decrease memory usage of inactive connections. - Clean allocated memory on exit. Helps to run memory-leak checkers. - Improve server_reset_query documentation. (#110) - Add TLS options to sample config. 2015-12-18 - PgBouncer 1.7 - "Colors Vary After Resurrection" - Support TLS connections. OpenSSL/LibreSSL is used as backend implementation. - Support authentication via TLS client certificate. - Support "peer" authentication on Unix sockets. - Support Host Based Access control file, like pg_hba.conf in Postgres. This allows to configure TLS for network connections and "peer" authentication for local connections. - Set query_wait_timeout to 120s by default. Current default (0) causes infinite queueing, which is not useful. That means if client has pending query and has not been assigned to server connection, the client connection will be dropped. - Disable server_reset_query_always by default. Now reset query is used only in pools that are in session mode. - Increase pkt_buf to 4096 bytes. Improves performance with TLS. The behaviour is probably load-specific, but it should be safe to do as since v1.2 the packet buffers are split from connections and used lazily from pool. - Support pipelining count expected ReadyForQuery packets. This avoids releasing server too early. Fixes #52. - Improved sbuf_loopcnt logic - socket is guarateed to be reprocessed even if there are no event from socket. Required for TLS as it has it's own buffering. - Adapt system tests to work with modern BSD and MacOS. (Eric Radman) - Remove crypt auth. It's obsolete and not supported by PostgreSQL since 8.4. - Fix plain "--with-cares" configure option - without argument it was broken. @ text @d1 1 a1 1 $NetBSD: patch-Makefile,v 1.1 2015/10/23 16:40:38 fhajny Exp $ d5 1 a5 1 --- Makefile.orig 2016-02-26 08:56:32.000000000 +0000 d7 2 a8 1 @@@@ -50,6 +50,8 @@@@ pgbouncer_EMBED_LIBUSUAL = 1 d11 2 a12 2 dist_doc_DATA = README.rst NEWS.rst etc/pgbouncer.ini etc/userlist.txt +dist_doc_DATA = README.rst NEWS.rst @ 1.1 log @Uddate databases/pgbouncer to 1.6.1. Update home page & master site, clean up. PgBouncer 1.6.1. - Security fix for CVE-2015-6817. - Per-pool pooling mode vs. reset query. Details: http://pgbouncer.github.io/2015/09/pgbouncer-1-6-1/ PgBouncer 1.6.0 Main new features: - Load user password hash from postgres database. - Pooling mode can be configured both per-database and per-user. - Per-database and per-user connection limits: max_db_connections and max_user_connections. - Add DISABLE/ENABLE commands to prevent new connections. - New preferred DNS backend: c-ares. - Config files have %include FILENAME directive to allow configuration to be split into several files. Details: http://pgbouncer.github.io/2015/08/pgbouncer-1-6/ PgBouncer 1.5.5 - Fix remote crash - invalid packet order causes lookup of NULL pointer. Not exploitable, just DoS. @ text @d1 1 a1 1 $NetBSD$ d5 1 a5 1 --- Makefile.orig 2015-09-03 14:46:31.000000000 +0000 d7 1 a7 2 @@@@ -47,7 +47,8 @@@@ AM_FEATURES = libusual pgbouncer_EMBED_LIBUSUAL = 1 d10 2 a11 2 -dist_doc_DATA = README NEWS etc/pgbouncer.ini etc/userlist.txt +dist_doc_DATA = README NEWS @