diff options
author | pi <pi@FreeBSD.org> | 2017-08-11 17:26:25 +0800 |
---|---|---|
committer | pi <pi@FreeBSD.org> | 2017-08-11 17:26:25 +0800 |
commit | 09bf1527ee3aee1d1b525e76b6110cf18b0ee25e (patch) | |
tree | b55e8fc861c2799264fd1cf8934b344c7fa5ec7d /databases | |
parent | c04ff5b4c899b82046454b9a7fd6508b7653e46c (diff) | |
download | freebsd-ports-gnome-09bf1527ee3aee1d1b525e76b6110cf18b0ee25e.tar.gz freebsd-ports-gnome-09bf1527ee3aee1d1b525e76b6110cf18b0ee25e.tar.zst freebsd-ports-gnome-09bf1527ee3aee1d1b525e76b6110cf18b0ee25e.zip |
New port: databases/pg_partman
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.
WWW: https://github.com/keithf4/pg_partman
PR: 214417
Submitted by: Lacey Powers <lacey.leanne@gmail.com>
Reviewed by: ler
Diffstat (limited to 'databases')
-rw-r--r-- | databases/Makefile | 1 | ||||
-rw-r--r-- | databases/pg_partman/Makefile | 27 | ||||
-rw-r--r-- | databases/pg_partman/distinfo | 3 | ||||
-rw-r--r-- | databases/pg_partman/pkg-descr | 10 | ||||
-rw-r--r-- | databases/pg_partman/pkg-plist | 73 |
5 files changed, 114 insertions, 0 deletions
diff --git a/databases/Makefile b/databases/Makefile index 411fb5d9e970..a8996ccf72e8 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -569,6 +569,7 @@ SUBDIR += pg_activity SUBDIR += pg_citus SUBDIR += pg_dirtyread + SUBDIR += pg_partman SUBDIR += pg_qualstats SUBDIR += pg_reorg SUBDIR += pg_repack diff --git a/databases/pg_partman/Makefile b/databases/pg_partman/Makefile new file mode 100644 index 000000000000..21c84f68f6b0 --- /dev/null +++ b/databases/pg_partman/Makefile @@ -0,0 +1,27 @@ +# $FreeBSD$ + +PORTNAME= pg_partman +PORTVERSION= 3.0.2 +CATEGORIES= databases + +MAINTAINER= lacey.leanne@gmail.com +COMMENT= PostgreSQL Partition Manager + +LICENSE= PostgreSQL + +RUN_DEPENDS+= ${PYTHON_SITELIBDIR}/psycopg2/__init__.py:databases/py-psycopg2 + +USES= gmake pgsql:9.4+ python uidfix shebangfix +WANT_PGSQL= server +SHEBANG_GLOB= *.py + +USE_GITHUB= yes +GH_TUPLE= keithf4:${PORTNAME}:v${PORTVERSION} + +post-install: + ${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 + +.include <bsd.port.mk> diff --git a/databases/pg_partman/distinfo b/databases/pg_partman/distinfo new file mode 100644 index 000000000000..6ca828571dc7 --- /dev/null +++ b/databases/pg_partman/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1499899689 +SHA256 (keithf4-pg_partman-3.0.2-v3.0.2_GH0.tar.gz) = 55176580061c8293ef972c78ce02b84f75687f284b13339248cffd44edc95946 +SIZE (keithf4-pg_partman-3.0.2-v3.0.2_GH0.tar.gz) = 816083 diff --git a/databases/pg_partman/pkg-descr b/databases/pg_partman/pkg-descr new file mode 100644 index 000000000000..7d779b77311d --- /dev/null +++ b/databases/pg_partman/pkg-descr @@ -0,0 +1,10 @@ +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. + +WWW: https://github.com/keithf4/pg_partman diff --git a/databases/pg_partman/pkg-plist b/databases/pg_partman/pkg-plist new file mode 100644 index 000000000000..6357d0b1f212 --- /dev/null +++ b/databases/pg_partman/pkg-plist @@ -0,0 +1,73 @@ +bin/check_unique_constraint.py +bin/dump_partition.py +bin/partition_data.py +bin/reapply_constraints.py +bin/reapply_foreign_keys.py +bin/reapply_indexes.py +bin/undo_partition.py +bin/vacuum_maintenance.py +lib/postgresql/pg_partman_bgw.so +%%PORTDOCS%%%%DOCSDIR%%/migration.md +%%PORTDOCS%%%%DOCSDIR%%/pg_partman.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.sql +share/postgresql/extension/pg_partman.control |