From owner-freebsd-ports-bugs@FreeBSD.ORG Thu May 14 19:50:02 2009 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0820C10656C5 for ; Thu, 14 May 2009 19:50:02 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id D70F78FC1C for ; Thu, 14 May 2009 19:50:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id n4EJo1Aa054311 for ; Thu, 14 May 2009 19:50:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n4EJo1GL054310; Thu, 14 May 2009 19:50:01 GMT (envelope-from gnats) Resent-Date: Thu, 14 May 2009 19:50:01 GMT Resent-Message-Id: <200905141950.n4EJo1GL054310@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Matthieu Bouthors Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 699AD1065674 for ; Thu, 14 May 2009 19:42:46 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 575578FC1B for ; Thu, 14 May 2009 19:42:46 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.3/8.14.3) with ESMTP id n4EJgjN0084479 for ; Thu, 14 May 2009 19:42:45 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id n4EJgj2T084476; Thu, 14 May 2009 19:42:45 GMT (envelope-from nobody) Message-Id: <200905141942.n4EJgj2T084476@www.freebsd.org> Date: Thu, 14 May 2009 19:42:45 GMT From: Matthieu Bouthors To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/134546: New port: databases/pgtune - Postgresql.conf tuning tips based on hardware and load type X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 14 May 2009 19:50:02 -0000 >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 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: