Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 11 Aug 2017 09:26:25 +0000 (UTC)
From:      Kurt Jaeger <pi@FreeBSD.org>
To:        ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org
Subject:   svn commit: r447749 - in head/databases: . pg_partman
Message-ID:  <201708110926.v7B9QP2d099363@repo.freebsd.org>

next in thread | raw e-mail | index | archive | help
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 <lacey.leanne@gmail.com>
  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 <bsd.port.mk>

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201708110926.v7B9QP2d099363>