From owner-svn-ports-all@freebsd.org Sat May 28 18:26:35 2016 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 3337CB4E819; Sat, 28 May 2016 18:26:35 +0000 (UTC) (envelope-from girgen@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 E88361D24; Sat, 28 May 2016 18:26:34 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id u4SIQYXW034511; Sat, 28 May 2016 18:26:34 GMT (envelope-from girgen@FreeBSD.org) Received: (from girgen@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id u4SIQXeh034504; Sat, 28 May 2016 18:26:33 GMT (envelope-from girgen@FreeBSD.org) Message-Id: <201605281826.u4SIQXeh034504@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: girgen set sender to girgen@FreeBSD.org using -f From: Palle Girgensohn Date: Sat, 28 May 2016 18:26:33 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r416058 - in head/databases: . pg_stat_kcache pg_stat_kcache/files X-SVN-Group: ports-head 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.22 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: Sat, 28 May 2016 18:26:35 -0000 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 +# $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 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