From nobody Thu Feb 13 02:38:14 2025 X-Original-To: dev-commits-ports-all@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 4YtfVt2l82z5ml11; Thu, 13 Feb 2025 02:38:14 +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 4YtfVt1T8Xz44Lw; Thu, 13 Feb 2025 02:38:14 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1739414294; 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=cktS1R3c5z0R4H/UtobExBVYYbHSPIRQ1i1MYOX5CPE=; b=Ni65ge1gsKtvWBovS+/UAKkHfDy+KOy8+cVfoKp/eM3Igggqr3MGW33ZtpkwuC87yqVE2u wyRYmj4T8eF4Bbhp2aqDIU3Gov4XSRRNI5PJM7Uqwb8itJWlTfJbxXesWF7P41a1pPir9S rnPSoXHMBpZnSvvJGeDG+cg9YH/bSwojr9ff0XlnuUYo+HMIgXjOWXFPxJ8gE0s+pEVR9A j2/HFoZy7yOEU2pLST01aBJCmqv6fsHECz4LMH8/RMbVf5zym7aj4ypeouGCOfAf24WAN9 blhlYgXfDa1sEV2KIz5cAYzQyb6g916yAYkocphxYZviUrbKzIn+sV8jnIdGYQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1739414294; 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=cktS1R3c5z0R4H/UtobExBVYYbHSPIRQ1i1MYOX5CPE=; b=m4+4lnGz7Dtj6Ah5RfN7/AKwkZ58iZOOpGh1dRMQ99njW/8EP6MLyoG0zL6PXFaY7S4i3c BgR1/jSSRWOMSdVIbvgQzmkSa3ryFdgcOaJIPM5YlIA9o7jGnuh3NgWYx3TbSE82obt6nW csFYE9jDCZPX1RTof/dstvnv10b7UCyucrm/8jEpVdxonnyCBx5YBS+pLSTuXlNgGjQNtO 6f57njN8XYaYarYYIGjX4GBKuSuT3agYD0MM7RR0+HVT4D3S/dcDigigMjKE54FeilvDtL 3ayNb3aRfP/Mmw5ZExniGHUgsjv7cQRmX2Kb1SzOzeJKlPgcQp235AkEtBUqkA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1739414294; a=rsa-sha256; cv=none; b=J8mAAC1HOcoAq95jNIThhMfrNCM0nNwED0slC9omWkeaFWtNsNBd/Si6oO9YyKwRyxSn1X YDqOveN4MBGcE2Gfc/k9EQbwwuY+KXKz3acNztlhDxPV9ckz+MOpm5SvkdwgKJNI3Pd7aV otldDDc90dqdauDe7KmrcQtODObNBK6UrN3q+4ye3WUdSSYPqVxMJuzTffXhsS2m4hnHdr r0fA2mmG0OR6OuS/2qmJnxvbnOEMUYu5UaN2Zjmmtt5HlI1sunleHWiDJNTC4znx/P149r zi1RXW/DIRaBqFVeCTTZCvjSp0uvrcnY1JaXx+3aUEXa8ncumBk94KwwpPj5SA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none 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 4YtfVt14Twz9jP; Thu, 13 Feb 2025 02:38:14 +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 51D2cE2X047973; Thu, 13 Feb 2025 02:38:14 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 51D2cE73047970; Thu, 13 Feb 2025 02:38:14 GMT (envelope-from git) Date: Thu, 13 Feb 2025 02:38:14 GMT Message-Id: <202502130238.51D2cE73047970@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Wen Heping Subject: git: e2a7b2520a52 - main - databases/pg_partman: Update to 5.2.2 List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-all@freebsd.org Sender: owner-dev-commits-ports-all@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: wen X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: e2a7b2520a527c858e4e3239655d5a24bed7021f Auto-Submitted: auto-generated The branch main has been updated by wen: URL: https://cgit.FreeBSD.org/ports/commit/?id=e2a7b2520a527c858e4e3239655d5a24bed7021f commit e2a7b2520a527c858e4e3239655d5a24bed7021f Author: Wen Heping AuthorDate: 2025-02-13 02:32:23 +0000 Commit: Wen Heping CommitDate: 2025-02-13 02:37:49 +0000 databases/pg_partman: Update to 5.2.2 Update pkg-descr PR: 283618 Reported by: bsd@abinet.ru Approved by: maintainer(timeout, > 40 days) --- databases/pg_partman/Makefile | 8 ++++---- databases/pg_partman/distinfo | 6 +++--- databases/pg_partman/pkg-descr | 24 ++++++++++++++++-------- databases/pg_partman/pkg-plist | 26 ++++++++++++++++++++------ 4 files changed, 43 insertions(+), 21 deletions(-) diff --git a/databases/pg_partman/Makefile b/databases/pg_partman/Makefile index 32224873b7ec..5891617cdf05 100644 --- a/databases/pg_partman/Makefile +++ b/databases/pg_partman/Makefile @@ -1,22 +1,22 @@ PORTNAME= pg_partman DISTVERSIONPREFIX= v -DISTVERSION= 4.6.0 +DISTVERSION= 5.2.2 CATEGORIES= databases MAINTAINER= lacey.leanne@gmail.com COMMENT= PostgreSQL Partition Manager -WWW= https://github.com/keithf4/pg_partman +WWW= https://github.com/pgpartman/pg_partman LICENSE= PostgreSQL LICENSE_FILE= ${WRKSRC}/LICENSE.txt RUN_DEPENDS= ${PYTHON_SITELIBDIR}/psycopg2/__init__.py:databases/py-psycopg2 -USES= cpe gmake pgsql:11+ python uidfix shebangfix +USES= cpe gmake pgsql:14+ python uidfix shebangfix CPE_VENDOR= pgxn USE_GITHUB= yes -GH_ACCOUNT= keithf4 +GH_ACCOUNT= pgpartman WANT_PGSQL= server SHEBANG_GLOB= *.py diff --git a/databases/pg_partman/distinfo b/databases/pg_partman/distinfo index b496981a4a44..e8be5fb7295c 100644 --- a/databases/pg_partman/distinfo +++ b/databases/pg_partman/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1634246278 -SHA256 (keithf4-pg_partman-v4.6.0_GH0.tar.gz) = 6328ea55e20a4f090037035751a02ebb7965d9e305e3839ffceb4c06bbbfa42f -SIZE (keithf4-pg_partman-v4.6.0_GH0.tar.gz) = 1200867 +TIMESTAMP = 1739411310 +SHA256 (pgpartman-pg_partman-v5.2.2_GH0.tar.gz) = c67898c7b131d66b835b44d92013e9e07f0834b253505ef2808de6826e3e558d +SIZE (pgpartman-pg_partman-v5.2.2_GH0.tar.gz) = 1247509 diff --git a/databases/pg_partman/pkg-descr b/databases/pg_partman/pkg-descr index 4a105a0d2818..2984e5f7e6a0 100644 --- a/databases/pg_partman/pkg-descr +++ b/databases/pg_partman/pkg-descr @@ -1,8 +1,16 @@ -pg_partman is an extension to create and manage both time-based and -serial-based table partition sets. Sub-partitoning is also supported. -Child table & trigger function creation is all managed by the extension -itself. Tables with existing data can also have their data partitioned in -easily managed smaller batches. Optional retention policy can automatically -drop partitions no longer needed. A background worker (BGW) process is -included to automatically run partition maintenance without the need of an -external scheduler (cron, etc) in most cases. +pg_partman is an extension to create and manage both time-based and number-based +table partition sets. As of version 5.0.1, only built-in, declarative +partitioning is supported and the older trigger-based methods have been +deprecated. + +The declarative partitioning built into PostgreSQL provides the commands to +create a partitioned table and its children. pg_partman uses the built-in +declarative features that PostgreSQL provides and builds upon those with +additional features and enhancements to make managing partitions easier. One key +way that pg_partman extends partitioning in Postgres is by providing a means to +automate the child table maintenance over time (Ex. adding new children, +dropping old ones based on a retention policy). pg_partman also has features to +turn an existing table into a partitioned table or vice versa. + +A background worker (BGW) process is included to automatically run partition +maintenance without the need of an external scheduler (cron, etc) in most cases. diff --git a/databases/pg_partman/pkg-plist b/databases/pg_partman/pkg-plist index 2dcfe76c29a4..d36baefd4dd2 100644 --- a/databases/pg_partman/pkg-plist +++ b/databases/pg_partman/pkg-plist @@ -1,13 +1,13 @@ bin/check_unique_constraint.py bin/dump_partition.py -bin/reapply_indexes.py bin/vacuum_maintenance.py lib/postgresql/pg_partman_bgw.so -%%PORTDOCS%%%%DOCSDIR%%/migrate_to_native.md -%%PORTDOCS%%%%DOCSDIR%%/migration_to_partman.md +%%PORTDOCS%%%%DOCSDIR%%/fix_missing_procedures.md +%%PORTDOCS%%%%DOCSDIR%%/migrate_to_declarative.md +%%PORTDOCS%%%%DOCSDIR%%/migrate_to_partman.md %%PORTDOCS%%%%DOCSDIR%%/pg_partman.md -%%PORTDOCS%%%%DOCSDIR%%/pg_partman_howto_native.md -%%PORTDOCS%%%%DOCSDIR%%/pg_partman_howto_triggerbased.md +%%PORTDOCS%%%%DOCSDIR%%/pg_partman_5.0.1_upgrade.md +%%PORTDOCS%%%%DOCSDIR%%/pg_partman_howto.md share/postgresql/extension/pg_partman--0.1.0--0.1.1.sql share/postgresql/extension/pg_partman--0.1.1--0.1.2.sql share/postgresql/extension/pg_partman--0.1.2--0.2.0.sql @@ -85,5 +85,19 @@ share/postgresql/extension/pg_partman--4.4.0--4.5.0.sql share/postgresql/extension/pg_partman--4.4.1--4.5.0.sql share/postgresql/extension/pg_partman--4.5.0--4.5.1.sql share/postgresql/extension/pg_partman--4.5.1--4.6.0.sql -share/postgresql/extension/pg_partman--4.6.0.sql +share/postgresql/extension/pg_partman--4.6.0--4.6.1.sql +share/postgresql/extension/pg_partman--4.6.1--4.6.2.sql +share/postgresql/extension/pg_partman--4.6.2--4.7.0.sql +share/postgresql/extension/pg_partman--4.7.0--4.7.1.sql +share/postgresql/extension/pg_partman--4.7.1--4.7.2.sql +share/postgresql/extension/pg_partman--4.7.2--4.7.3.sql +share/postgresql/extension/pg_partman--4.7.3--4.7.4.sql +share/postgresql/extension/pg_partman--4.7.4--4.8.0.sql +share/postgresql/extension/pg_partman--4.8.0--5.0.0.sql +share/postgresql/extension/pg_partman--5.0.0--5.0.1.sql +share/postgresql/extension/pg_partman--5.0.1--5.1.0.sql +share/postgresql/extension/pg_partman--5.1.0--5.2.0.sql +share/postgresql/extension/pg_partman--5.2.0--5.2.1.sql +share/postgresql/extension/pg_partman--5.2.1--5.2.2.sql +share/postgresql/extension/pg_partman--5.2.2.sql share/postgresql/extension/pg_partman.control