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,40 +1,40 @@ 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 LLD_UNSAFE= yes OPTIONS_DEFINE= DOCS post-install: ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pg_partman_bgw.so post-install-DOCS-on: ${MKDIR} ${STAGEDIR}${DOCSDIR} ${MV} ${STAGEDIR}${PREFIX}/share/doc/postgresql/extension/*.md ${STAGEDIR}${DOCSDIR} ${RMDIR} ${STAGEDIR}${PREFIX}/share/doc/postgresql/extension ${RMDIR} ${STAGEDIR}${PREFIX}/share/doc/postgresql post-install-DOCS-off: ${RM} -r ${STAGEDIR}${PREFIX}/share/doc/postgresql .include 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,89 +1,103 @@ 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 share/postgresql/extension/pg_partman--0.2.0--0.3.0.sql share/postgresql/extension/pg_partman--0.3.0--0.3.1.sql share/postgresql/extension/pg_partman--0.3.1--0.3.2.sql share/postgresql/extension/pg_partman--0.3.2--0.4.0.sql share/postgresql/extension/pg_partman--0.4.0--0.4.1.sql share/postgresql/extension/pg_partman--0.4.1--0.4.2.sql share/postgresql/extension/pg_partman--0.4.2--1.0.0.sql share/postgresql/extension/pg_partman--1.0.0--1.1.0.sql share/postgresql/extension/pg_partman--1.1.0--1.2.0.sql share/postgresql/extension/pg_partman--1.2.0--1.3.0.sql share/postgresql/extension/pg_partman--1.3.0--1.4.0.sql share/postgresql/extension/pg_partman--1.4.0--1.4.1.sql share/postgresql/extension/pg_partman--1.4.1--1.4.2.sql share/postgresql/extension/pg_partman--1.4.2--1.4.3.sql share/postgresql/extension/pg_partman--1.4.3--1.4.4.sql share/postgresql/extension/pg_partman--1.4.4--1.4.5.sql share/postgresql/extension/pg_partman--1.4.5--1.5.0.sql share/postgresql/extension/pg_partman--1.5.0--1.5.1.sql share/postgresql/extension/pg_partman--1.5.1--1.6.0.sql share/postgresql/extension/pg_partman--1.6.0--1.6.1.sql share/postgresql/extension/pg_partman--1.6.1--1.7.0.sql share/postgresql/extension/pg_partman--1.7.0--1.7.1.sql share/postgresql/extension/pg_partman--1.7.1--1.7.2.sql share/postgresql/extension/pg_partman--1.7.2--1.8.0.sql share/postgresql/extension/pg_partman--1.8.0--1.8.1.sql share/postgresql/extension/pg_partman--1.8.1--1.8.2.sql share/postgresql/extension/pg_partman--1.8.2--1.8.3.sql share/postgresql/extension/pg_partman--1.8.3--1.8.4.sql share/postgresql/extension/pg_partman--1.8.4--1.8.5.sql share/postgresql/extension/pg_partman--1.8.5--1.8.6.sql share/postgresql/extension/pg_partman--1.8.6--1.8.7.sql share/postgresql/extension/pg_partman--1.8.7--1.8.8.sql share/postgresql/extension/pg_partman--1.8.7--2.0.0.sql share/postgresql/extension/pg_partman--1.8.8--2.0.0.sql share/postgresql/extension/pg_partman--2.0.0--2.1.0.sql share/postgresql/extension/pg_partman--2.1.0--2.2.0.sql share/postgresql/extension/pg_partman--2.2.0--2.2.1.sql share/postgresql/extension/pg_partman--2.2.1--2.2.2.sql share/postgresql/extension/pg_partman--2.2.2--2.2.3.sql share/postgresql/extension/pg_partman--2.2.3--2.3.0.sql share/postgresql/extension/pg_partman--2.3.0--2.3.1.sql share/postgresql/extension/pg_partman--2.3.1--2.3.2.sql share/postgresql/extension/pg_partman--2.3.2--2.3.3.sql share/postgresql/extension/pg_partman--2.3.3--2.3.4.sql share/postgresql/extension/pg_partman--2.3.4--2.4.0.sql share/postgresql/extension/pg_partman--2.4.0--2.4.1.sql share/postgresql/extension/pg_partman--2.4.1--2.5.0.sql share/postgresql/extension/pg_partman--2.5.0--2.5.1.sql share/postgresql/extension/pg_partman--2.5.1--2.6.0.sql share/postgresql/extension/pg_partman--2.6.0--2.6.1.sql share/postgresql/extension/pg_partman--2.6.1--2.6.2.sql share/postgresql/extension/pg_partman--2.6.2--2.6.3.sql share/postgresql/extension/pg_partman--2.6.3--2.6.4.sql share/postgresql/extension/pg_partman--2.6.4--3.0.0.sql share/postgresql/extension/pg_partman--3.0.0--3.0.1.sql share/postgresql/extension/pg_partman--3.0.1--3.0.2.sql share/postgresql/extension/pg_partman--3.0.2--3.1.0.sql share/postgresql/extension/pg_partman--3.1.0--3.1.1.sql share/postgresql/extension/pg_partman--3.1.1--3.1.2.sql share/postgresql/extension/pg_partman--3.1.2--3.1.3.sql share/postgresql/extension/pg_partman--3.1.3--3.2.0.sql share/postgresql/extension/pg_partman--3.2.0--3.2.1.sql share/postgresql/extension/pg_partman--3.2.1--4.0.0.sql share/postgresql/extension/pg_partman--4.0.0--4.1.0.sql share/postgresql/extension/pg_partman--4.1.0--4.2.0.sql share/postgresql/extension/pg_partman--4.2.0--4.2.1.sql share/postgresql/extension/pg_partman--4.2.1--4.2.2.sql share/postgresql/extension/pg_partman--4.2.2--4.3.0.sql share/postgresql/extension/pg_partman--4.3.0--4.3.1.sql share/postgresql/extension/pg_partman--4.3.1--4.4.0.sql 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