Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 6 Jul 2017 10:10:08 +0000 (UTC)
From:      Torsten Zuehlsdorff <tz@FreeBSD.org>
To:        ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org
Subject:   svn commit: r445133 - in head/databases: . pg_repack
Message-ID:  <201707061010.v66AA8xX029764@repo.freebsd.org>

next in thread | raw e-mail | index | archive | help
Author: tz
Date: Thu Jul  6 10:10:08 2017
New Revision: 445133
URL: https://svnweb.freebsd.org/changeset/ports/445133

Log:
  New port: databases/pg_repack
  
  Pg_repack is a PostgreSQL extension which lets you remove bloat from tables and
  indexes, and optionally restore the physical order of clustered indexes. Unlike
  CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on
  the processed tables during processing. pg_repack is efficient to boot, with
  performance comparable to using CLUSTER directly.
  
  WWW: https://github.com/reorg/pg_repack
  
  PR:           219679
  Submitted by: Jov <amutu@amutu.com>

Added:
  head/databases/pg_repack/
  head/databases/pg_repack/Makefile   (contents, props changed)
  head/databases/pg_repack/distinfo   (contents, props changed)
  head/databases/pg_repack/pkg-descr   (contents, props changed)
Modified:
  head/databases/Makefile

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Thu Jul  6 09:56:13 2017	(r445132)
+++ head/databases/Makefile	Thu Jul  6 10:10:08 2017	(r445133)
@@ -568,6 +568,7 @@
     SUBDIR += pg_citus
     SUBDIR += pg_qualstats
     SUBDIR += pg_reorg
+    SUBDIR += pg_repack
     SUBDIR += pg_rman
     SUBDIR += pg_stat_kcache
     SUBDIR += pg_statsinfo

Added: head/databases/pg_repack/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_repack/Makefile	Thu Jul  6 10:10:08 2017	(r445133)
@@ -0,0 +1,30 @@
+# Created by: Jov <amutu@amutu.com>
+# $FreeBSD$
+
+PORTNAME=	pg_repack
+PORTVERSION=	1.4.0.1
+DISTVERSIONPREFIX=	ver_
+CATEGORIES=	databases
+PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+
+MAINTAINER=	amutu@amutu.com
+COMMENT=	Reorganize tables in PostgreSQL databases with minimal locks
+
+LICENSE=	BSD3CLAUSE
+
+USES=		gmake pgsql:9.2+
+USE_GITHUB=	yes
+GH_ACCOUNT=	reorg
+
+WANT_PGSQL=	server
+
+PLIST_FILES=	bin/pg_repack \
+		lib/postgresql/pg_repack.so \
+		share/postgresql/extension/pg_repack--1.4.0.sql \
+		share/postgresql/extension/pg_repack.control
+
+post-install:
+	        ${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/pg_repack \
+		       ${STAGEDIR}${PREFIX}/lib/postgresql/pg_repack.so
+
+.include <bsd.port.mk>

Added: head/databases/pg_repack/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_repack/distinfo	Thu Jul  6 10:10:08 2017	(r445133)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1496220411
+SHA256 (reorg-pg_repack-ver_1.4.0.1_GH0.tar.gz) = fb5594ebbc25c83c1939736b3f97c430e60e48934ef9498062527ffa73e21a64
+SIZE (reorg-pg_repack-ver_1.4.0.1_GH0.tar.gz) = 90995

Added: head/databases/pg_repack/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_repack/pkg-descr	Thu Jul  6 10:10:08 2017	(r445133)
@@ -0,0 +1,7 @@
+Pg_repack is a PostgreSQL extension which lets you remove bloat from tables and
+indexes, and optionally restore the physical order of clustered indexes. Unlike
+CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on
+the processed tables during processing. pg_repack is efficient to boot, with
+performance comparable to using CLUSTER directly.
+
+WWW: https://github.com/reorg/pg_repack



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