Date: Thu, 14 May 2009 19:42:45 GMT From: Matthieu Bouthors <matthieu@labs.fr> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/134546: New port: databases/pgtune - Postgresql.conf tuning tips based on hardware and load type Message-ID: <200905141942.n4EJgj2T084476@www.freebsd.org> Resent-Message-ID: <200905141950.n4EJo1GL054310@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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@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@dirrm share/pgtune/settings X@dirrm share/pgtune END-of-pgtune/pkg-plist exit >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200905141942.n4EJgj2T084476>