svn commit: r416058 - in head/databases: . pg_stat_kcache pg_stat_kcache/files

[Palle Girgensohn]

Author: girgen
Date: Sat May 28 18:26:33 2016
New Revision: 416058
URL: https://svnweb.freebsd.org/changeset/ports/416058

Log:
  Add pg_stat_kcache module
  
  Gathers statistics about real reads and writes done by the filesystem layer. It
  is provided in the form of an extension for PostgreSQL >= 9.4., and requires
  pg_stat_statements extension to be installed. PostgreSQL 9.4 or more is
  required as previous version of provided pg_stat_statements didn't expose the
  queryid field.
  
  WWW:	https://github.com/dalibo/pg_stat_kcache

Added:
  head/databases/pg_stat_kcache/
  head/databases/pg_stat_kcache/Makefile   (contents, props changed)
  head/databases/pg_stat_kcache/distinfo   (contents, props changed)
  head/databases/pg_stat_kcache/files/
  head/databases/pg_stat_kcache/files/patch-Makefile   (contents, props changed)
  head/databases/pg_stat_kcache/pkg-descr   (contents, props changed)
  head/databases/pg_stat_kcache/pkg-message   (contents, props changed)
  head/databases/pg_stat_kcache/pkg-plist   (contents, props changed)
Modified:
  head/databases/Makefile

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Sat May 28 17:29:16 2016	(r416057)
+++ head/databases/Makefile	Sat May 28 18:26:33 2016	(r416058)
@@ -554,6 +554,7 @@
     SUBDIR += pg_citus
     SUBDIR += pg_reorg
     SUBDIR += pg_rman
+    SUBDIR += pg_stat_kcache
     SUBDIR += pg_statsinfo
     SUBDIR += pgaccess
     SUBDIR += pgadmin3

Added: head/databases/pg_stat_kcache/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/Makefile	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,21 @@
+# Created by: Palle Girgensohn <girgen at FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME=	pg_stat_kcache
+PORTVERSION=	2.0.2
+CATEGORIES=	databases
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	dalibo
+GH_TAGNAME=	REL2_0_2
+
+MAINTAINER=	girgen at FreeBSD.org
+COMMENT=	Gather statistics about PostgreSQL I/O and CPU usage 
+
+USES=		gmake pgsql:9.4+
+WANT_PGSQL=	server contrib
+
+pre-patch:
+	@${MV} ${BUILD_WRKSRC}/README.rst ${BUILD_WRKSRC}/${PORTNAME}-README.rst
+
+.include <bsd.port.mk>

Added: head/databases/pg_stat_kcache/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/distinfo	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,2 @@
+SHA256 (dalibo-pg_stat_kcache-2.0.2-REL2_0_2_GH0.tar.gz) = 72b8850c7ede052bce2a51aa6a11b3ec1db2214dcea3911be0aa5324040154f1
+SIZE (dalibo-pg_stat_kcache-2.0.2-REL2_0_2_GH0.tar.gz) = 9731

Added: head/databases/pg_stat_kcache/files/patch-Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/files/patch-Makefile	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,11 @@
+--- Makefile.orig	2016-01-21 22:44:44.214163699 +0100
++++ Makefile	2016-01-21 22:44:51.788162213 +0100
+@@ -3,7 +3,7 @@
+ TESTS        = $(wildcard test/sql/*.sql)
+ REGRESS      = $(patsubst test/sql/%.sql,%,$(TESTS))
+ REGRESS_OPTS = --inputdir=test
+-DOCS         = $(wildcard README.rst)
++DOCS         = $(wildcard *-README.rst)
+ 
+ PG_CONFIG = pg_config
+ 

Added: head/databases/pg_stat_kcache/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/pkg-descr	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,4 @@
+Gathers statistics about real reads and writes done by the filesystem layer. It
+is provided in the form of an extension for PostgreSQL >= 9.4.
+
+WWW:	https://github.com/dalibo/pg_stat_kcache

Added: head/databases/pg_stat_kcache/pkg-message
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/pkg-message	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,7 @@
+To activate pg_stat_kcache on your PostgreSQL server, add 'pg_stat_kcache' to
+shared_preload_libraries in ~pgsql/data/postgresql.conf. For every database,
+run
+	CREATE EXTENSION IF NOT EXISTS pg_stat_kcache
+
+Using databases/powa-web and databases/powa-archivist together with
+pg_stat_kcache is warmly recommended.

Added: head/databases/pg_stat_kcache/pkg-plist
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/pg_stat_kcache/pkg-plist	Sat May 28 18:26:33 2016	(r416058)
@@ -0,0 +1,5 @@
+lib/postgresql/pg_stat_kcache.so
+share/doc/postgresql/extension/pg_stat_kcache-README.rst
+share/postgresql/extension/pg_stat_kcache--2.0.1--2.0.2.sql
+share/postgresql/extension/pg_stat_kcache--2.0.2.sql
+share/postgresql/extension/pg_stat_kcache.control