svn commit: r422953 - in head/databases: . pg_qualstats pg_qualstats/files powa-archivist powa-web
Palle Girgensohn
girgen at FreeBSD.org
Thu Sep 29 22:42:21 UTC 2016
Author: girgen
Date: Thu Sep 29 22:42:19 2016
New Revision: 422953
URL: https://svnweb.freebsd.org/changeset/ports/422953
Log:
Add a suite of real time metrics tools for PostgreSQL
The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and
later, allowing to collect, aggregate and purge statistics on a PostgreSQL
instance from various sources. It is implemented as a background worker.
pg_qualstats, providing data about predicates, i.e. where clauses
Added:
head/databases/pg_qualstats/
head/databases/pg_qualstats/Makefile (contents, props changed)
head/databases/pg_qualstats/distinfo (contents, props changed)
head/databases/pg_qualstats/files/
head/databases/pg_qualstats/files/patch-Makefile (contents, props changed)
head/databases/pg_qualstats/pkg-descr (contents, props changed)
head/databases/pg_qualstats/pkg-message (contents, props changed)
head/databases/pg_qualstats/pkg-plist (contents, props changed)
head/databases/powa-archivist/
head/databases/powa-archivist/Makefile (contents, props changed)
head/databases/powa-archivist/distinfo (contents, props changed)
head/databases/powa-archivist/pkg-descr (contents, props changed)
head/databases/powa-archivist/pkg-message (contents, props changed)
head/databases/powa-archivist/pkg-plist (contents, props changed)
head/databases/powa-web/
head/databases/powa-web/Makefile (contents, props changed)
head/databases/powa-web/distinfo (contents, props changed)
head/databases/powa-web/pkg-descr (contents, props changed)
Modified:
head/databases/Makefile
Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile Thu Sep 29 22:21:51 2016 (r422952)
+++ head/databases/Makefile Thu Sep 29 22:42:19 2016 (r422953)
@@ -559,6 +559,7 @@
SUBDIR += pg_citus
SUBDIR += pg_reorg
SUBDIR += pg_rman
+ SUBDIR += pg_qualstats
SUBDIR += pg_stat_kcache
SUBDIR += pg_statsinfo
SUBDIR += pgaccess
@@ -708,6 +709,8 @@
SUBDIR += postgresql96-plpython
SUBDIR += postgresql96-pltcl
SUBDIR += postgresql96-server
+ SUBDIR += powa-archivist
+ SUBDIR += powa-web
SUBDIR += powerarchitect
SUBDIR += proftpd-mod_sql_mysql
SUBDIR += proftpd-mod_sql_odbc
Added: head/databases/pg_qualstats/Makefile
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/Makefile Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,23 @@
+# Created by: Palle Girgensohn <girgen at FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME= pg_qualstats
+PORTVERSION= 1.0.1
+CATEGORIES= databases
+
+MAINTAINER= girgen at FreeBSD.org
+COMMENT= PostgreSQL extension for collecting statistics about predicates
+
+LICENSE_FILE= ${WRKSRC}/LICENSE
+
+USE_GITHUB= yes
+GH_ACCOUNT= dalibo
+
+USES= gmake pgsql:9.4+
+WANT_PGSQL= server
+
+pre-patch:
+ @${MV} ${BUILD_WRKSRC}/doc/README.md ${BUILD_WRKSRC}/doc/${PORTNAME}-README.md ;\
+ ${MV} ${BUILD_WRKSRC}/LICENSE ${BUILD_WRKSRC}/${PORTNAME}-LICENSE
+
+.include <bsd.port.mk>
Added: head/databases/pg_qualstats/distinfo
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/distinfo Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1475181222
+SHA256 (dalibo-pg_qualstats-1.0.1_GH0.tar.gz) = a1e39e65044b2b52f837067a3dccd70a22f5c51bcef898c95ac9ea4951aeee38
+SIZE (dalibo-pg_qualstats-1.0.1_GH0.tar.gz) = 22319
Added: head/databases/pg_qualstats/files/patch-Makefile
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/files/patch-Makefile Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,11 @@
+--- Makefile.orig 2016-08-11 13:49:47 UTC
++++ Makefile
+@@ -3,7 +3,7 @@ EXTVERSION = $(shell grep default_vers
+ TESTS = $(wildcard test/sql/*.sql)
+ REGRESS = $(patsubst test/sql/%.sql,%,$(TESTS))
+ REGRESS_OPTS = --inputdir=test
+-DOCS = $(wildcard doc/*.md)
++DOCS = $(wildcard doc/*.md) $(wildcard *LICENSE)
+ MODULES = $(patsubst %.c,%,$(wildcard *.c))
+ PG_CONFIG ?= pg_config
+
Added: head/databases/pg_qualstats/pkg-descr
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/pkg-descr Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,4 @@
+pg_qualstats is a PostgreSQL extension keeping statistics on predicates found
+in WHERE statements and JOIN clauses.
+
+WWW: https://github.com/dalibo/pg_qualstats
Added: head/databases/pg_qualstats/pkg-message
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/pkg-message Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,7 @@
+To activate pg_qualstats on your PostgreSQL server, add 'pg_qualstats' to
+shared_preload_libraries in $PGDATA/postgresql.conf. For every database,
+run
+ CREATE EXTENSION IF NOT EXISTS pg_qualstats.
+
+Using databases/powa-web and databases/powa-archivist together with
+pg_qualstats is warmly recommended.
Added: head/databases/pg_qualstats/pkg-plist
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/pg_qualstats/pkg-plist Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,15 @@
+lib/postgresql/pg_qualstats.so
+share/postgresql/extension/pg_qualstats--0.0.1.sql
+share/postgresql/extension/pg_qualstats--0.0.2.sql
+share/postgresql/extension/pg_qualstats--0.0.3.sql
+share/postgresql/extension/pg_qualstats--0.0.4.sql
+share/postgresql/extension/pg_qualstats--0.0.5.sql
+share/postgresql/extension/pg_qualstats--0.0.6.sql
+share/postgresql/extension/pg_qualstats--0.0.7.sql
+share/postgresql/extension/pg_qualstats--0.0.8.sql
+share/postgresql/extension/pg_qualstats--0.0.9.sql
+share/postgresql/extension/pg_qualstats--1.0.0.sql
+share/postgresql/extension/pg_qualstats--1.0.1.sql
+share/postgresql/extension/pg_qualstats.control
+share/doc/postgresql/extension/pg_qualstats-README.md
+share/doc/postgresql/extension/pg_qualstats-LICENSE
Added: head/databases/powa-archivist/Makefile
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-archivist/Makefile Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,26 @@
+# Created by: Palle Girgensohn <girgen at FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME= powa-archivist
+PORTVERSION= 3.1.0
+CATEGORIES= databases
+
+MAINTAINER= girgen at FreeBSD.org
+COMMENT= PostgreSQL workload analyzer background worker
+
+LICENSE= PostgreSQL
+
+RUN_DEPENDS= ${LOCALBASE}/lib/postgresql/pg_stat_kcache.so:databases/pg_stat_kcache \
+ ${LOCALBASE}/lib/postgresql/pg_qualstats.so:databases/pg_qualstats
+
+USE_GITHUB= yes
+GH_ACCOUNT= dalibo
+GH_TAGNAME= REL_${PORTVERSION:S/./_/g}
+
+USES= gmake pgsql
+WANT_PGSQL= server contrib
+
+pre-patch:
+ @for f in ${BUILD_WRKSRC}/*.md; do ${MV} $$f $${f%/*}/powa-$${f##*/}; done
+
+.include <bsd.port.mk>
Added: head/databases/powa-archivist/distinfo
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-archivist/distinfo Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1474452329
+SHA256 (dalibo-powa-archivist-3.1.0-REL_3_1_0_GH0.tar.gz) = 9dc7f80b24202ca47f2a21e9a08240096a9deb02ce93c939d45088c98180a803
+SIZE (dalibo-powa-archivist-3.1.0-REL_3_1_0_GH0.tar.gz) = 46328
Added: head/databases/powa-archivist/pkg-descr
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-archivist/pkg-descr Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,5 @@
+This project is the core extension of the PoWA project, a PostgreSQL Workload
+Analyzer that gathers performance stats and provides real-time charts and
+graphs to help monitor and tune your PostgreSQL servers.
+
+WWW: http://powa.readthedocs.org/en/latest/powa-archivist/index.html
Added: head/databases/powa-archivist/pkg-message
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-archivist/pkg-message Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,24 @@
+To activate powa-archvist on your PostgreSQL server, add 'powa' to the list of
+shared_preload_libraries in $PGDATA/postgresql.conf:
+
+shared_preload_libraries = 'pg_stat_statements,powa'
+track_io_timing = on
+
+Also, create the powa database and add extensions
+
+createdb powa
+psql -d powa -c "
+CREATE EXTENSION pg_stat_statements;
+CREATE EXTENSION btree_gist;
+CREATE EXTENSION powa;
+"
+
+After this, restart postgresql to start the background worker.
+
+See http://powa.readthedocs.org/en/latest/powa-archivist/installation.html#id1
+for detailed installation instructions.
+
+Optionally, but warmly recommended, is the use of databases/pg_qualstats and
+databases/pg_stat_kcache together with powa.
+
+Use the databases/powa-web port to visualize the data.
Added: head/databases/powa-archivist/pkg-plist
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-archivist/pkg-plist Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,15 @@
+lib/postgresql/powa.so
+share/doc/postgresql/extension/powa-CHANGELOG.md
+share/doc/postgresql/extension/powa-CONTRIBUTORS.md
+share/doc/postgresql/extension/powa-INSTALL.md
+share/doc/postgresql/extension/powa-LICENSE.md
+share/doc/postgresql/extension/powa-PL_funcs.md
+share/doc/postgresql/extension/powa-README.md
+share/postgresql/extension/powa--2.0--2.0.1.sql
+share/postgresql/extension/powa--2.0.1.sql
+share/postgresql/extension/powa--3.0.0--3.0.1.sql
+share/postgresql/extension/powa--3.0.0.sql
+share/postgresql/extension/powa--3.0.1.sql
+share/postgresql/extension/powa--3.0.1--3.1.0.sql
+share/postgresql/extension/powa--3.1.0.sql
+share/postgresql/extension/powa.control
Added: head/databases/powa-web/Makefile
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-web/Makefile Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,25 @@
+# Created by: Palle Girgensohn <girgen at FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME= powa-web
+PORTVERSION= 3.0.2
+CATEGORIES= databases python
+MASTER_SITES= CHEESESHOP
+PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX}
+
+MAINTAINER= girgen at FreeBSD.org
+COMMENT= PostgreSQL Workload Analyzer is a performance tool for PostgreSQL
+
+LICENSE= PostgreSQL
+
+RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}psycopg2>0:databases/py-psycopg2 \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy10>=1.0:databases/py-sqlalchemy10 \
+ ${PYTHON_PKGNAMEPREFIX}tornado>=2.0:www/py-tornado
+
+USES= python
+USE_PYTHON= distutils autoplist
+
+post-patch:
+ ${REINPLACE_CMD} 's,/etc/powa-web.conf,${PREFIX}/etc/powa-web.conf,' ${WRKSRC}/powa/options.py
+
+.include <bsd.port.mk>
Added: head/databases/powa-web/distinfo
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-web/distinfo Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1475181200
+SHA256 (powa-web-3.0.2.tar.gz) = 1417dca2ea87c7d8f7b9d309cbe874c7a36120b911f395bda0fc5596dc11cf8c
+SIZE (powa-web-3.0.2.tar.gz) = 593768
Added: head/databases/powa-web/pkg-descr
==============================================================================
--- /dev/null 00:00:00 1970 (empty, because file is newly added)
+++ head/databases/powa-web/pkg-descr Thu Sep 29 22:42:19 2016 (r422953)
@@ -0,0 +1,9 @@
+The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and
+later versions, allowing to collect, aggregate and purge statistics on a
+PostgreSQL instance from various sources. It is implemented as a background
+worker.
+
+Install databases/powa-archivist on your database servers, and this port
+on any achine with psql access to the databases.
+
+WWW: http://powa.readthedocs.org/
More information about the svn-ports-all
mailing list