From nobody Fri Dec 27 19:23:30 2024 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4YKb4y69J3z5jCNr; Fri, 27 Dec 2024 19:23:30 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4YKb4y59Gwz4NQy; Fri, 27 Dec 2024 19:23:30 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1735327410; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=164a1rh0lO+ch4OvjjHdDodvJAS330VmPlWtdpQYfls=; b=aNoxiWZwXbK559b2rpKbakInuFJzks/76tbGBj74nTInfKTLqOdGHMw2dmnoHVgAPc5oN8 MjyhnHFTgL1xe2BSnfk3kAMTJ7B3gY079NxQ5U/xHB8FXgPuRzud48xzbtK8YUItl9dlzM HHNPfa0y9I4Tsqh5VUVJm6th5FjF737O/6MmAkOZkT5LgWjY4tqa9yC3mznIfPWnzxggo3 7CIOEMGfZUFg/ETDg/DyfQbgGDxbwBlzL2iGWP83HSDr4SFtNJi+oRvl/CueqWj84YY8kW a/EGf7CX4afkTCpf/zTUPicovMqg39OwBPwWpMTnO4QIvh4drHEzmoE6DmSCfw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1735327410; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=164a1rh0lO+ch4OvjjHdDodvJAS330VmPlWtdpQYfls=; b=uBUE5EmVAZHt4nGlbUiB9fbbe+XDiJlUBKKJDdThxzvwJT6fT+WLR/3FF2Z9R2HHT4O/UZ x4XPlcYOaMR5zIpWBtQUZsXaPIivt9MDGcHTUApeZG530zMNAlkNtPhDTziqxRmddrpKpg szzQF3+NescrP4o1XDTMyrMAVd+61gejkzjH7hIWgpX38BRiEltQu1d38mWVg7fl1Mx3jO cfvtzWIkQOVslmFnRD8qN6vK4u716zACRBrepxsgdhC/FkOcycBbDzHQJJpnyG136fyBFE 8FDcMjzErcLrJIouI4Eym9Oz/Dc/eD++P9DW09QGKmrNhsFTYlpXG1jf1jsSRg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1735327410; a=rsa-sha256; cv=none; b=EAk1Z4E6VDtBmbirXA2tsDLs1fIJkWLL6mDEjDExi9qLKOrg18jj6q3vT03y9oAFHhsmxU V1ZQmWwZ7kO75bTtbivUYbgZ9wmu+9Jnwhc3LrrNdv/2d+nM4e9WXVwsMg8lhMKAmISXDt ySAV18g8aUZ0ZdmoY3eNFDeo0MGrrXxsg5Xs2htE7pg5ypt6lVVToNmzOrri2MZSE/D/EF Z0VZNd60le+0T55dZpxlZIzB21lf3JLZ2e62sObfMKiUFYEVlrl03PgGznznZ9eEWoq4K7 OktLDAIEpdOPrCawb3kgTCo9pUJOykO9PceE3alYJvXlfzCKDPhzlwON2f9w8Q== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4YKb4y4mSgzrPV; Fri, 27 Dec 2024 19:23:30 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.18.1/8.18.1) with ESMTP id 4BRJNUdU000639; Fri, 27 Dec 2024 19:23:30 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 4BRJNURr000636; Fri, 27 Dec 2024 19:23:30 GMT (envelope-from git) Date: Fri, 27 Dec 2024 19:23:30 GMT Message-Id: <202412271923.4BRJNURr000636@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Zsolt Udvari Subject: git: a8abd9ed4d7d - main - databases/pgbouncer: Update to 1.23.1 List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-main@freebsd.org Sender: owner-dev-commits-ports-main@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: uzsolt X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: a8abd9ed4d7d33c641a74a7f2606338515a935ef Auto-Submitted: auto-generated The branch main has been updated by uzsolt: URL: https://cgit.FreeBSD.org/ports/commit/?id=a8abd9ed4d7d33c641a74a7f2606338515a935ef commit a8abd9ed4d7d33c641a74a7f2606338515a935ef Author: Älven AuthorDate: 2024-12-27 19:19:21 +0000 Commit: Zsolt Udvari CommitDate: 2024-12-27 19:22:02 +0000 databases/pgbouncer: Update to 1.23.1 Improve pkg-descr. Add LICENSE_FILE. Switch to DISTVERSION. PR: 283466 Approved by: Dmitry Wagin (maintainer) --- databases/pgbouncer/Makefile | 6 +++--- databases/pgbouncer/distinfo | 6 +++--- databases/pgbouncer/pkg-descr | 34 +++++++++++++++++++++++++++++++++- 3 files changed, 39 insertions(+), 7 deletions(-) diff --git a/databases/pgbouncer/Makefile b/databases/pgbouncer/Makefile index e61ea879ea40..867c56b2c9c5 100644 --- a/databases/pgbouncer/Makefile +++ b/databases/pgbouncer/Makefile @@ -1,14 +1,14 @@ PORTNAME= pgbouncer -PORTVERSION= 1.22.1 +DISTVERSION= 1.23.1 CATEGORIES= databases -MASTER_SITES= https://www.pgbouncer.org/downloads/files/${PORTVERSION}/ \ - http://www.pgbouncer.org/downloads/files/${PORTVERSION}/ +MASTER_SITES= https://www.pgbouncer.org/downloads/files/${DISTVERSION}/ MAINTAINER= dmitry.wagin@ya.ru COMMENT= Lightweight connection pooler for PostgreSQL WWW= https://www.pgbouncer.org/ LICENSE= BSD2CLAUSE +LICENSE_FILE= ${WRKSRC}/COPYRIGHT LIB_DEPENDS= libevent.so:devel/libevent diff --git a/databases/pgbouncer/distinfo b/databases/pgbouncer/distinfo index 3a5f02bca9e9..1232ed485344 100644 --- a/databases/pgbouncer/distinfo +++ b/databases/pgbouncer/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1709578392 -SHA256 (pgbouncer-1.22.1.tar.gz) = 2b018aa6ce7f592c9892bb9e0fd90262484eb73937fd2af929770a45373ba215 -SIZE (pgbouncer-1.22.1.tar.gz) = 677351 +TIMESTAMP = 1734778449 +SHA256 (pgbouncer-1.23.1.tar.gz) = 1963b497231d9a560a62d266e4a2eae6881ab401853d93e5d292c3740eec5084 +SIZE (pgbouncer-1.23.1.tar.gz) = 700025 diff --git a/databases/pgbouncer/pkg-descr b/databases/pgbouncer/pkg-descr index 177292cc8c26..a4690341723d 100644 --- a/databases/pgbouncer/pkg-descr +++ b/databases/pgbouncer/pkg-descr @@ -1 +1,33 @@ -Lightweight connection pooler for PostgreSQL. +PgBouncer is a PostgreSQL connection pooler. Any target application can be +connected to PgBouncer as if it were a PostgreSQL server, and PgBouncer will +create a connection to the actual server, or it will reuse one of its existing +connections. + +The aim of PgBouncer is to lower the performance impact of opening new +connections to PostgreSQL. + +In order not to compromise transaction semantics for connection pooling, +PgBouncer supports several types of pooling when rotating connections: + +* Session pooling + +Most polite method. When a client connects, a server connection will be assigned +to it for the whole duration it stays connected. When the client disconnects, +the server connection will be put back into pool. This mode supports all +PostgreSQL features. + +* Transaction pooling + +A server connection is assigned to a client only during a transaction. When +PgBouncer notices that the transaction is over, the server will be put back into +the pool. + +This mode breaks a few session-based features of PostgreSQL. You can use it only +when the application cooperates by not using features that break. See the table +below for incompatible 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 the client, mostly targeted at PL/Proxy.