pgtune takes the wimpy default postgresql.conf and expands

the database server to be as powerful as the hardware it's
being deployed on.

WWW: http://pgfoundry.org/projects/pgtune/

PR:		ports/134546
Submitted by:	Matthieu BOUTHORS

6 files changed, 56 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index d4d8c3026913..399c7856da33 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -440,6 +440,7 @@
     SUBDIR += pgpoolAdmin
     SUBDIR += pgtcl
     SUBDIR += pgtop
+    SUBDIR += pgtune
     SUBDIR += pgworksheet
     SUBDIR += php-adodb-ext
     SUBDIR += php-sqlite3
diff --git a/databases/pgtune/Makefile b/databases/pgtune/Makefile
new file mode 100644
index 000000000000..7bf30ad96af0
--- /dev/null
+++ b/databases/pgtune/Makefile
@@ -0,0 +1,25 @@
+# New ports collection makefile for:   pgtune
+# Date created:        16 feb 2009
+# Whom:                Matthieu BOUTHORS
+#
+# $FreeBSD$
+#
+
+PORTNAME=	pgtune
+PORTVERSION=	0.9.0
+CATEGORIES=	databases
+MASTER_SITES=	http://pgfoundry.org/frs/download.php/2068/ \
+		http://mirror.labs.fr/pub/FreeBSD/distfiles/
+
+MAINTAINER=	matthieu@labs.fr
+COMMENT=	Postgresql.conf tuning tips based on hardware and load type
+
+USE_PYTHON=	yes
+NO_BUILD=	yes
+
+do-install:
+	${INSTALL_SCRIPT} ${WRKSRC}/pgtune  ${PREFIX}/bin/pgtune
+	${MKDIR} ${PREFIX}/share/pgtune/settings/
+	${CP} ${WRKSRC}/pg_settings* ${PREFIX}/share/pgtune/settings/
+
+.include <bsd.port.mk>
diff --git a/databases/pgtune/distinfo b/databases/pgtune/distinfo
new file mode 100644
index 000000000000..d8f8e7291c4b
--- /dev/null
+++ b/databases/pgtune/distinfo
@@ -0,0 +1,3 @@
+MD5 (pgtune-0.9.0.tar.gz) = 1cdff4886dcdc27687ae15ae71c8b8f3
+SHA256 (pgtune-0.9.0.tar.gz) = 864960dd100bb234eacd63803befe0a35d251cc48d41abfadf321eb82335b92d
+SIZE (pgtune-0.9.0.tar.gz) = 22414
diff --git a/databases/pgtune/files/patch-pgtune b/databases/pgtune/files/patch-pgtune
new file mode 100644
index 000000000000..73639f2c4721
--- /dev/null
+++ b/databases/pgtune/files/patch-pgtune
@@ -0,0 +1,17 @@
+--- pgtune-original 2009-01-26 17:11:05.000000000 +0100
++++ pgtune 2009-02-18 08:20:59.000000000 +0100
+@@ -1,4 +1,4 @@
+-#!/usr/bin/python
++#!/usr/local/bin/python
+ """
+ pgtune
+ 
+@@ -248,7 +248,7 @@
+     if platform.architecture()[0]=="64bit":  platformBits=64
+     # TODO Base this file location on where this script is at
+     # TODO Support handling versions other than 8.4
+-    settingDumpFile="pg_settings-8.4-"+str(platformBits)
++    settingDumpFile="/usr/local/share/pgtune/settings/pg_settings-8.4-"+str(platformBits)
+     settingColumns=["name","setting","unit","category","short_desc",
+       "extra_desc","context","vartype","min_val","max_val","enumvals",
+       "boot_val"]
diff --git a/databases/pgtune/pkg-descr b/databases/pgtune/pkg-descr
new file mode 100644
index 000000000000..cf94a6e44a31
--- /dev/null
+++ b/databases/pgtune/pkg-descr
@@ -0,0 +1,5 @@
+pgtune takes the wimpy default postgresql.conf and expands
+the database server to be as powerful as the hardware it's
+being deployed on.
+
+WWW: http://pgfoundry.org/projects/pgtune/
diff --git a/databases/pgtune/pkg-plist b/databases/pgtune/pkg-plist
new file mode 100644
index 000000000000..9b8c31706268
--- /dev/null
+++ b/databases/pgtune/pkg-plist
@@ -0,0 +1,5 @@
+bin/pgtune
+share/pgtune/settings/pg_settings-8.4-32
+share/pgtune/settings/pg_settings-8.4-64
+@dirrm share/pgtune/settings
+@dirrm share/pgtune