ports/134546: New port: databases/pgtune - Postgresql.conf tuning tips based on hardware and load type

[Matthieu Bouthors]

>Number:         134546
>Category:       ports
>Synopsis:       New port: databases/pgtune - Postgresql.conf tuning tips based on hardware and load type
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Thu May 14 19:50:01 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Matthieu Bouthors
>Release:        FreeBSD 7.0-RELEASE
>Organization:
>Environment:
FreeBSD ks.labs.fr 7.0-RELEASE FreeBSD 7.0-RELEASE #0: Wed Feb  4 19:49:50 CET 2009     root at ks.labs.fr:/usr/obj/usr/src/sys/KSLABS  amd64
>Description:
Here is the .shar as an attachement in order to add pgtune (http://pgfoundry.org/projects/pgtune/) in ports tree (category: databases)

Features:
=============

* pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on
* total memory automatic detection
* takes into account specific parameters (DBType, max connections expected)

Requirements:
=============
* python

Author:
=============
Greg Smith (http://pgfoundry.org/users/gsmith/)

>How-To-Repeat:

>Fix:
# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
# pgtune
# pgtune/Makefile
# pgtune/files
# pgtune/files/patch-pgtune
# pgtune/pkg-descr
# pgtune/distinfo
# pgtune/pkg-plist
#
echo c - pgtune
mkdir -p pgtune > /dev/null 2>&1
echo x - pgtune/Makefile
sed 's/^X//' >pgtune/Makefile << 'END-of-pgtune/Makefile'
X# New ports collection makefile for:   pgtune
X# Date created:        16 feb 2009
X# Whom:                Matthieu BOUTHORS
X#
X# $FreeBSD$
X#
X
XPORTNAME= pgtune
XPORTVERSION= 0.9
XCATEGORIES= databases
XMASTER_SITES= http://pgfoundry.org/frs/download.php/2068/ \
X  http://mirror.labs.fr/pub/FreeBSD/distfiles/
XDISTNAME= pgtune-0.9.0
X
XMAINTAINER= matthieu at labs.fr
XCOMMENT= Postgresql.conf tuning tips based on hardware and load type
X
XRUN_DEPENDS= python:${PORTSDIR}/lang/python
X
XNO_BUILD= yes
X
Xdo-install:
X ${INSTALL_SCRIPT} ${WRKSRC}/pgtune ${PREFIX}/bin/pgtune
X
Xpost-install:
X ${MKDIR} ${PREFIX}/share/pgtune/settings/
X ${CP} ${WRKSRC}/pg_settings* ${PREFIX}/share/pgtune/settings/
X
X.include <bsd.port.mk>
END-of-pgtune/Makefile
echo c - pgtune/files
mkdir -p pgtune/files > /dev/null 2>&1
echo x - pgtune/files/patch-pgtune
sed 's/^X//' >pgtune/files/patch-pgtune << 'END-of-pgtune/files/patch-pgtune'
X--- pgtune-original 2009-01-26 17:11:05.000000000 +0100
X+++ pgtune 2009-02-18 08:20:59.000000000 +0100
X@@ -1,4 +1,4 @@
X-#!/usr/bin/python
X+#!/usr/local/bin/python
X """
X pgtune
X 
X@@ -248,7 +248,7 @@
X     if platform.architecture()[0]=="64bit":  platformBits=64
X     # TODO Base this file location on where this script is at
X     # TODO Support handling versions other than 8.4
X-    settingDumpFile="pg_settings-8.4-"+str(platformBits)
X+    settingDumpFile="/usr/local/share/pgtune/settings/pg_settings-8.4-"+str(platformBits)
X     settingColumns=["name","setting","unit","category","short_desc",
X       "extra_desc","context","vartype","min_val","max_val","enumvals",
X       "boot_val"]
END-of-pgtune/files/patch-pgtune
echo x - pgtune/pkg-descr
sed 's/^X//' >pgtune/pkg-descr << 'END-of-pgtune/pkg-descr'
Xpgtune takes the wimpy default postgresql.conf and expands the database server 
Xto be as powerful as the hardware it's being deployed on.
X
XWWW: http://pgfoundry.org/projects/pgtune/
END-of-pgtune/pkg-descr
echo x - pgtune/distinfo
sed 's/^X//' >pgtune/distinfo << 'END-of-pgtune/distinfo'
XMD5 (pgtune-0.9.0.tar.gz) = 1cdff4886dcdc27687ae15ae71c8b8f3
XSHA256 (pgtune-0.9.0.tar.gz) = 864960dd100bb234eacd63803befe0a35d251cc48d41abfadf321eb82335b92d
XSIZE (pgtune-0.9.0.tar.gz) = 22414
END-of-pgtune/distinfo
echo x - pgtune/pkg-plist
sed 's/^X//' >pgtune/pkg-plist << 'END-of-pgtune/pkg-plist'
Xbin/pgtune
Xshare/pgtune/settings/pg_settings-8.4-32
Xshare/pgtune/settings/pg_settings-8.4-64
X at dirrm share/pgtune/settings
X at dirrm share/pgtune
END-of-pgtune/pkg-plist
exit


>Release-Note:
>Audit-Trail:
>Unformatted: