CVS commit: pkgsrc/databases/pgbouncer

["Thomas Klausner" <wiz%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   wiz
Date:           Thu Apr 11 06:55:27 UTC 2024

Modified Files:
        pkgsrc/databases/pgbouncer: Makefile PLIST distinfo
        pkgsrc/databases/pgbouncer/patches: patch-Makefile

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


To generate a diff of this commit:
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/pgbouncer/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/pgbouncer/PLIST
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/pgbouncer/distinfo
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/pgbouncer/patches/patch-Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/pgbouncer/Makefile
diff -u pkgsrc/databases/pgbouncer/Makefile:1.17 pkgsrc/databases/pgbouncer/Makefile:1.18
--- pkgsrc/databases/pgbouncer/Makefile:1.17    Tue Oct 24 22:08:31 2023
+++ pkgsrc/databases/pgbouncer/Makefile Thu Apr 11 06:55:27 2024
@@ -1,8 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2023/10/24 22:08:31 wiz Exp $
-#
+# $NetBSD: Makefile,v 1.18 2024/04/11 06:55:27 wiz Exp $
 
-DISTNAME=      pgbouncer-1.10.0
-PKGREVISION=   2
+DISTNAME=      pgbouncer-1.22.1
 CATEGORIES=    databases
 MASTER_SITES=  http://pgbouncer.github.io/downloads/files/${PKGVERSION_NOREV}/
 
@@ -12,7 +10,7 @@ COMMENT=      Lightweight connection pooler f
 LICENSE=       original-bsd
 
 USE_LANGUAGES= c
-USE_TOOLS+=    gmake
+USE_TOOLS+=    gmake pkg-config
 GNU_CONFIGURE= yes
 
 .include "../../mk/bsd.prefs.mk"
@@ -49,7 +47,6 @@ SUBST_SED.path+=      -e 's|/etc/pgbouncer|${
 SUBST_SED.path+=       -e 's|userlist.txt|pgbouncer.userlist|g'
 
 CONFIGURE_ARGS+=       --with-cares=${BUILDLINK_PREFIX.libcares}
-CONFIGURE_ARGS+=       --with-libevent=${BUILDLINK_PREFIX.libevent}
 
 CPPFLAGS.SunOS+=       -D_STRUCTURED_PROC=1
 

Index: pkgsrc/databases/pgbouncer/PLIST
diff -u pkgsrc/databases/pgbouncer/PLIST:1.5 pkgsrc/databases/pgbouncer/PLIST:1.6
--- pkgsrc/databases/pgbouncer/PLIST:1.5        Wed Aug 14 14:19:38 2019
+++ pkgsrc/databases/pgbouncer/PLIST    Thu Apr 11 06:55:27 2024
@@ -1,8 +1,11 @@
-@comment $NetBSD: PLIST,v 1.5 2019/08/14 14:19:38 fox Exp $
+@comment $NetBSD: PLIST,v 1.6 2024/04/11 06:55:27 wiz Exp $
 bin/pgbouncer
 man/man1/pgbouncer.1
 man/man5/pgbouncer.5
 share/doc/pgbouncer/NEWS.md
 share/doc/pgbouncer/README.md
+share/doc/pgbouncer/pgbouncer.service
+share/doc/pgbouncer/pgbouncer.socket
+share/examples/pgbouncer/pgbouncer-minimal.ini
 share/examples/pgbouncer/pgbouncer.ini
 share/examples/pgbouncer/userlist.txt

Index: pkgsrc/databases/pgbouncer/distinfo
diff -u pkgsrc/databases/pgbouncer/distinfo:1.12 pkgsrc/databases/pgbouncer/distinfo:1.13
--- pkgsrc/databases/pgbouncer/distinfo:1.12    Tue Oct 26 10:09:43 2021
+++ pkgsrc/databases/pgbouncer/distinfo Thu Apr 11 06:55:27 2024
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.12 2021/10/26 10:09:43 nia Exp $
+$NetBSD: distinfo,v 1.13 2024/04/11 06:55:27 wiz Exp $
 
-BLAKE2s (pgbouncer-1.10.0.tar.gz) = 157fa199308bd6fc2853be48733bdf08e8a029074db7976d55b169e81b5737a6
-SHA512 (pgbouncer-1.10.0.tar.gz) = 8ec9f102b57ca5f92fb689588ec090056ac29f21825400ec67bca413fe076ad50e0b491e65c4cfebc488cc245eb3c88c36db2ee0ba1cb737f35404be0983dd1d
-Size (pgbouncer-1.10.0.tar.gz) = 480571 bytes
-SHA1 (patch-Makefile) = 91a59289d4fcd4b8258ed191f2deeb1e24853106
+BLAKE2s (pgbouncer-1.22.1.tar.gz) = b88eb7d1499ee266a2e29c03968fd9824028524f1e5e7f6aa18d785420a24f3a
+SHA512 (pgbouncer-1.22.1.tar.gz) = ac63fe877f68745f1faab096ee9d9e185de9cab97d4fef121c2c551fa0e69ea22342dc8b5ce75cadff755314e5493a5440f0748b5ee9f524f71d871ec1861530
+Size (pgbouncer-1.22.1.tar.gz) = 677351 bytes
+SHA1 (patch-Makefile) = 810c25a5ea7d03f60b909d2659ff9f89bf7a772f

Index: pkgsrc/databases/pgbouncer/patches/patch-Makefile
diff -u pkgsrc/databases/pgbouncer/patches/patch-Makefile:1.3 pkgsrc/databases/pgbouncer/patches/patch-Makefile:1.4
--- pkgsrc/databases/pgbouncer/patches/patch-Makefile:1.3       Wed Aug 14 14:19:38 2019
+++ pkgsrc/databases/pgbouncer/patches/patch-Makefile   Thu Apr 11 06:55:27 2024
@@ -1,16 +1,24 @@
-$NetBSD: patch-Makefile,v 1.3 2019/08/14 14:19:38 fox Exp $
+$NetBSD: patch-Makefile,v 1.4 2024/04/11 06:55:27 wiz Exp $
 
-Install sample config files as... config files.
+Install example files in pkgsrc default examples directory.
 
---- Makefile.orig      2019-07-01 04:00:00.000000000 -0400
-+++ Makefile
-@@ -51,7 +51,8 @@
- pgbouncer_EMBED_LIBUSUAL = 1
+--- 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.ini etc/userlist.txt
-+dist_doc_DATA = README.md NEWS.md
-+dist_sysconf_DATA = etc/pgbouncer.ini etc/userlist.txt
+ 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