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.

3 files changed, 52 insertions, 0 deletions

diff --git a/databases/postgresql90-monitoring/DESCR b/databases/postgresql90-monitoring/DESCR
new file mode 100644
index 00000000000..a7d6d0fd016
--- /dev/null
+++ b/databases/postgresql90-monitoring/DESCR
@@ -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 --git a/databases/postgresql90-monitoring/Makefile b/databases/postgresql90-monitoring/Makefile
new file mode 100644
index 00000000000..9928e1ed327
--- /dev/null
+++ b/databases/postgresql90-monitoring/Makefile
@@ -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 --git a/databases/postgresql90-monitoring/PLIST b/databases/postgresql90-monitoring/PLIST
new file mode 100644
index 00000000000..aa0d0ea9eba
--- /dev/null
+++ b/databases/postgresql90-monitoring/PLIST
@@ -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