aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--databases/Makefile1
-rw-r--r--databases/pgtune/Makefile25
-rw-r--r--databases/pgtune/distinfo3
-rw-r--r--databases/pgtune/files/patch-pgtune17
-rw-r--r--databases/pgtune/pkg-descr5
-rw-r--r--databases/pgtune/pkg-plist5
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