[pkgsrc/trunk]: pkgsrc/databases/postgresql90-monitoring Import PostgreSQL 9....

[asau <asau%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/e642f8fffdd4
branches:  trunk
changeset: 583200:e642f8fffdd4
user:      asau <asau%pkgsrc.org@localhost>
date:      Fri Dec 10 19:21:06 2010 +0000

description:
Import PostgreSQL 9.0 monitoring modules as databases/postgresql90-monitoring

This package provides the following PostgreSQL modules:
  - auto_explain
  - pg_buffercache
  - pg_stat_statements
  - pgstattuple

The "auto_explain" module provides a means for logging execution
plans of slow statements automatically, without having to run
EXPLAIN(7) by hand. This is especially helpful for tracking down
un-optimized queries in large applications.

The "pg_buffercache" module provides a means for examining what's
happening in the shared buffer cache in real time.

The "pg_stat_statements" module provides a means for tracking
execution statistics of all SQL statements executed by a server.

The "pgstattuple" module provides various functions to obtain
tuple-level statistics.

diffstat:

 databases/postgresql90-monitoring/DESCR    |  19 +++++++++++++++++++
 databases/postgresql90-monitoring/Makefile |  22 ++++++++++++++++++++++
 databases/postgresql90-monitoring/PLIST    |  11 +++++++++++
 3 files changed, 52 insertions(+), 0 deletions(-)

diffs (64 lines):

diff -r ff36a650e081 -r e642f8fffdd4 databases/postgresql90-monitoring/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql90-monitoring/DESCR   Fri Dec 10 19:21:06 2010 +0000
@@ -0,0 +1,19 @@
+This package provides the following PostgreSQL modules:
+  - auto_explain
+  - pg_buffercache
+  - pg_stat_statements
+  - pgstattuple
+
+The "auto_explain" module provides a means for logging execution
+plans of slow statements automatically, without having to run
+EXPLAIN(7) by hand. This is especially helpful for tracking down
+un-optimized queries in large applications.
+
+The "pg_buffercache" module provides a means for examining what's
+happening in the shared buffer cache in real time.
+
+The "pg_stat_statements" module provides a means for tracking
+execution statistics of all SQL statements executed by a server.
+
+The "pgstattuple" module provides various functions to obtain
+tuple-level statistics.
diff -r ff36a650e081 -r e642f8fffdd4 databases/postgresql90-monitoring/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql90-monitoring/Makefile        Fri Dec 10 19:21:06 2010 +0000
@@ -0,0 +1,22 @@
+# $NetBSD: Makefile,v 1.1.1.1 2010/12/10 19:21:06 asau Exp $
+
+PKGNAME=       postgresql90-monitoring-${BASE_VERS}
+COMMENT=       PostgreSQL monitoring tools
+
+PKG_DESTDIR_SUPPORT=   user-destdir
+
+DEPENDS+=      postgresql90-server>=${BASE_VERS}:../../databases/postgresql90-server
+
+.include "../../databases/postgresql90/Makefile.common"
+
+BUILD_DIRS+=           contrib/auto_explain
+BUILD_DIRS+=           contrib/pg_buffercache
+BUILD_DIRS+=           contrib/pg_stat_statements
+BUILD_DIRS+=           contrib/pgstattuple
+
+USE_LIBTOOL=           yes
+PKG_LIBTOOL=           ${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql90-client/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r ff36a650e081 -r e642f8fffdd4 databases/postgresql90-monitoring/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql90-monitoring/PLIST   Fri Dec 10 19:21:06 2010 +0000
@@ -0,0 +1,11 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2010/12/10 19:21:06 asau Exp $
+${PG_SUBPREFIX}lib/libauto_explain.la
+${PG_SUBPREFIX}lib/libpg_buffercache.la
+${PG_SUBPREFIX}lib/libpg_stat_statements.la
+${PG_SUBPREFIX}lib/libpgstattuple.la
+${PG_SUBPREFIX}share/postgresql/contrib/pg_buffercache.sql
+${PG_SUBPREFIX}share/postgresql/contrib/pg_stat_statements.sql
+${PG_SUBPREFIX}share/postgresql/contrib/pgstattuple.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pg_buffercache.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pg_stat_statements.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_pgstattuple.sql