diff options
| -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 |