From owner-svn-ports-all@freebsd.org Fri Aug 11 09:26:27 2017 Return-Path: Delivered-To: svn-ports-all@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 2BC64DB60BE; Fri, 11 Aug 2017 09:26:27 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 065EA693E7; Fri, 11 Aug 2017 09:26:26 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id v7B9QQNm099368; Fri, 11 Aug 2017 09:26:26 GMT (envelope-from pi@FreeBSD.org) Received: (from pi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id v7B9QP2d099363; Fri, 11 Aug 2017 09:26:25 GMT (envelope-from pi@FreeBSD.org) Message-Id: <201708110926.v7B9QP2d099363@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: pi set sender to pi@FreeBSD.org using -f From: Kurt Jaeger Date: Fri, 11 Aug 2017 09:26:25 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r447749 - in head/databases: . pg_partman X-SVN-Group: ports-head X-SVN-Commit-Author: pi X-SVN-Commit-Paths: in head/databases: . pg_partman X-SVN-Commit-Revision: 447749 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Aug 2017 09:26:27 -0000 Author: pi Date: Fri Aug 11 09:26:25 2017 New Revision: 447749 URL: https://svnweb.freebsd.org/changeset/ports/447749 Log: 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 Reviewed by: ler Added: head/databases/pg_partman/ head/databases/pg_partman/Makefile (contents, props changed) head/databases/pg_partman/distinfo (contents, props changed) head/databases/pg_partman/pkg-descr (contents, props changed) head/databases/pg_partman/pkg-plist (contents, props changed) Modified: head/databases/Makefile Modified: head/databases/Makefile ============================================================================== --- head/databases/Makefile Fri Aug 11 08:45:02 2017 (r447748) +++ head/databases/Makefile Fri Aug 11 09:26:25 2017 (r447749) @@ -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 Added: head/databases/pg_partman/Makefile ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_partman/Makefile Fri Aug 11 09:26:25 2017 (r447749) @@ -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 Added: head/databases/pg_partman/distinfo ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_partman/distinfo Fri Aug 11 09:26:25 2017 (r447749) @@ -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 Added: head/databases/pg_partman/pkg-descr ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_partman/pkg-descr Fri Aug 11 09:26:25 2017 (r447749) @@ -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 Added: head/databases/pg_partman/pkg-plist ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_partman/pkg-plist Fri Aug 11 09:26:25 2017 (r447749) @@ -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