[Midnightbsd-cvs] mports [24464] trunk/databases: add pgtune

[laffer1 at midnightbsd.org]

Revision: 24464
          http://svnweb.midnightbsd.org/mports/?rev=24464
Author:   laffer1
Date:     2018-10-14 15:42:50 -0400 (Sun, 14 Oct 2018)
Log Message:
-----------
add pgtune

Modified Paths:
--------------
    trunk/databases/Makefile

Added Paths:
-----------
    trunk/databases/pgtune/
    trunk/databases/pgtune/Makefile
    trunk/databases/pgtune/distinfo
    trunk/databases/pgtune/files/
    trunk/databases/pgtune/files/patch-pgtune
    trunk/databases/pgtune/pkg-descr
    trunk/databases/pgtune/pkg-plist

Modified: trunk/databases/Makefile
===================================================================
--- trunk/databases/Makefile	2018-10-14 18:22:14 UTC (rev 24463)
+++ trunk/databases/Makefile	2018-10-14 19:42:50 UTC (rev 24464)
@@ -73,6 +73,7 @@
 SUBDIR += percona55-client
 SUBDIR += percona55-server
 SUBDIR += pgtcl
+SUBDIR += pgtune
 SUBDIR += php56-dba
 SUBDIR += php56-mssql
 SUBDIR += php56-mysql

Added: trunk/databases/pgtune/Makefile
===================================================================
--- trunk/databases/pgtune/Makefile	                        (rev 0)
+++ trunk/databases/pgtune/Makefile	2018-10-14 19:42:50 UTC (rev 24464)
@@ -0,0 +1,26 @@
+# $MidnightBSD$
+
+PORTNAME=	pgtune
+PORTVERSION=	0.9.3
+CATEGORIES=	databases
+MASTER_SITES=	http://pgfoundry.org/frs/download.php/2449/ \
+		https://www.glenbarber.us/ports/${CATEGORIES}/${PORTNAME}/
+
+MAINTAINER=	ports at MidnightBSD.org
+COMMENT=	Postgresql.conf tuning tips based on hardware and load type
+
+LICENSE=	bsd3
+LICENSE_FILE=	${WRKSRC}/COPYRIGHT
+
+USES=		python:2.7,run shebangfix
+SHEBANG_FILES=	${PORTNAME}
+NO_BUILD=	yes
+NO_ARCH=	yes
+
+do-install:
+	${INSTALL_SCRIPT} ${WRKSRC}/pgtune ${STAGEDIR}${PREFIX}/bin
+	@${MKDIR} ${STAGEDIR}${PREFIX}/share/pgtune/settings
+	${INSTALL_DATA} ${WRKSRC}/pg_settings* \
+		${STAGEDIR}${PREFIX}/share/pgtune/settings
+
+.include <bsd.port.mk>


Property changes on: trunk/databases/pgtune/Makefile
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:keywords
## -0,0 +1 ##
+MidnightBSD=%H
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: trunk/databases/pgtune/distinfo
===================================================================
--- trunk/databases/pgtune/distinfo	                        (rev 0)
+++ trunk/databases/pgtune/distinfo	2018-10-14 19:42:50 UTC (rev 24464)
@@ -0,0 +1,2 @@
+SHA256 (pgtune-0.9.3.tar.gz) = 31ac5774766dd9793d8d2d3681d1edb45760897c8eda3afc48b8d59350dee0ea
+SIZE (pgtune-0.9.3.tar.gz) = 34408


Property changes on: trunk/databases/pgtune/distinfo
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: trunk/databases/pgtune/files/patch-pgtune
===================================================================
--- trunk/databases/pgtune/files/patch-pgtune	                        (rev 0)
+++ trunk/databases/pgtune/files/patch-pgtune	2018-10-14 19:42:50 UTC (rev 24464)
@@ -0,0 +1,11 @@
+--- pgtune.orig	2009-10-29 01:16:39 UTC
++++ pgtune
+@@ -277,7 +277,7 @@ class pg_settings(object):
+     if platform.architecture()[0]=="64bit":  platformBits=64
+     # TODO Support handling versions other than 8.4
+     # TODO Allow passing in platform bit size
+-    settingDumpFile=os.path.join(settings_dir,"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"]


Property changes on: trunk/databases/pgtune/files/patch-pgtune
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: trunk/databases/pgtune/pkg-descr
===================================================================
--- trunk/databases/pgtune/pkg-descr	                        (rev 0)
+++ trunk/databases/pgtune/pkg-descr	2018-10-14 19:42:50 UTC (rev 24464)
@@ -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/


Property changes on: trunk/databases/pgtune/pkg-descr
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: trunk/databases/pgtune/pkg-plist
===================================================================
--- trunk/databases/pgtune/pkg-plist	                        (rev 0)
+++ trunk/databases/pgtune/pkg-plist	2018-10-14 19:42:50 UTC (rev 24464)
@@ -0,0 +1,3 @@
+bin/pgtune
+share/pgtune/settings/pg_settings-8.4-32
+share/pgtune/settings/pg_settings-8.4-64


Property changes on: trunk/databases/pgtune/pkg-plist
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property