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

7 files changed, 51 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index f11e76c3c44f..ef33e6515acd 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -554,6 +554,7 @@
     SUBDIR += pg_citus
     SUBDIR += pg_reorg
     SUBDIR += pg_rman
+    SUBDIR += pg_stat_kcache
     SUBDIR += pg_statsinfo
     SUBDIR += pgaccess
     SUBDIR += pgadmin3
diff --git a/databases/pg_stat_kcache/Makefile b/databases/pg_stat_kcache/Makefile
new file mode 100644
index 000000000000..1bfc74929005
--- /dev/null
+++ b/databases/pg_stat_kcache/Makefile
@@ -0,0 +1,21 @@
+# Created by: Palle Girgensohn <girgen@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@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>
diff --git a/databases/pg_stat_kcache/distinfo b/databases/pg_stat_kcache/distinfo
new file mode 100644
index 000000000000..c2f4a3d2af50
--- /dev/null
+++ b/databases/pg_stat_kcache/distinfo
@@ -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
diff --git a/databases/pg_stat_kcache/files/patch-Makefile b/databases/pg_stat_kcache/files/patch-Makefile
new file mode 100644
index 000000000000..af4a31841e69
--- /dev/null
+++ b/databases/pg_stat_kcache/files/patch-Makefile
@@ -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
+ 
diff --git a/databases/pg_stat_kcache/pkg-descr b/databases/pg_stat_kcache/pkg-descr
new file mode 100644
index 000000000000..299f67edaa19
--- /dev/null
+++ b/databases/pg_stat_kcache/pkg-descr
@@ -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
diff --git a/databases/pg_stat_kcache/pkg-message b/databases/pg_stat_kcache/pkg-message
new file mode 100644
index 000000000000..687b17e7af95
--- /dev/null
+++ b/databases/pg_stat_kcache/pkg-message
@@ -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.
diff --git a/databases/pg_stat_kcache/pkg-plist b/databases/pg_stat_kcache/pkg-plist
new file mode 100644
index 000000000000..c9385261a689
--- /dev/null
+++ b/databases/pg_stat_kcache/pkg-plist
@@ -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